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

Question

1vote

Can I set if loop to do nothing if boolean is 'false'

Hi,

i have a database where we keep track of tasks and we would like to keep track how long the task stayed in a particular 'status'

e.g. i have a 'status' property which would have values like, 'Backlog', In Progress', 'Done' and i would like to keep track of how many days this DB entry has stayed in each of these values.

At the moment I thought to create three other properties to keep track of when the item's 'status' property changed to 'Backlog', 'In Progress', 'Done' - by doing so i can derive how much time since they've changed between each other.

I tried the formula if(prop("Status")=="Backlog",now(),"") as I want this property to do nothing if the 'status' property is NOT "Backlog" but I am getting a 'Type Mismatch "" is not a Date.' error.

1 Answer

0vote

polle Points79460

Notion formulas can't write dates by status.

You will need an external tool like make or Zapier to create an automation and write dates based on your needs.

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!

Connect