IF function based on status column, calculate date

I’m tryng to set the formula, when status changes to someting, then calculate date between Creation date and today. I’d like to erase “ture” when the answer if false, but have no idea how to do that.

Currently I’m using
IF({Stages}=“13. Contract Signed”, ROUND(DAYS(TODAY(), {Creation date#Date}),0))

Thank you!


1 Like

Amazing information!


Try: IF({Stages}="13. Contract Signed", ROUND(DAYS(TODAY(), {Creation date#Date}),0), "")

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday

1 Like

Ohhh I missed ) in my function :((
Thank you!!!

1 Like

Further to this, can anyone recommend a code checker to use for these?

I wasted a bunch of time yesterday messing around with an IF function because “ were the wrong ones.