Question

The question^.

I'm using the notion API and I am unable to figure out a way with which I can check at which date/time the status is changed to a special status so that I can use that date as a start date to be populated/used in other fields of the same task.

If anyone can help, it would be really appreciated, thanks in advance.

Answer 1

For the future comers, I was able to solve this using:

• A dedicated hidden "change status date" column of type formula then use the following formula:

  if(prop("Status") == "In progress", now(), fromTimestamp(toNumber("")))

Then for further actions, that column's value can be used as a "start date" for other columns.