Notion Answers

Help between Notion users

Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution



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.

1 Answer


ashishjullia96 Points250

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.


polle commented

Thank you for sharing!

Please log in or register to answer this question.


Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!