Calculate Difference in Days depending on Status


I’m trying to create a formula that will calculate the difference in days from today when the status is Working on It, and then calculate the difference in days when between 2 date columns when the status is Approved. I have a formula that mostly works, but when I change the status to Approved it just says “true” instead of actually showing the difference in days.

IF({Status} = “Working on it”, ROUNDUP(DAYS(TODAY(), {Date}),0), {Status} = “Approved”, ROUND(DAYS({Date 2}, {Date}),0))

Any ideas on how I can get it to show the actual days when the status is Approved instead of it says true?


Try this:

IF({Status} = "Working on it", ROUNDUP(DAYS(TODAY(), {Date}), 0), "") & IF({Status} = "Approved", ROUND(DAYS({Date 2}, {Date}), 0),"")

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Column Total in Formulas? YES!!!

That did it!! Thank you so much!!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.