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
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
Ohhh I missed ) in my function :((
Thank you!!!
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.
