IF function based on status column, calculate date

[davelight (JaeHyeok Lee)]

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

[josephmack]

Amazing information!

[JCorrell (Jim - The Monday Man)]

@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

[davelight (JaeHyeok Lee)]

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

[eClaireS (Claire Sowden)]

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.