Hi,
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!
i
1 Like
@davelight
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.