IF function based on status column, calculate date

Workflows Formulas
1

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!

image
image878×478 29.1 KB

i

1 Like
2

Amazing information!

3

@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
4

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

1 Like
5

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.