Hello! We are trying to use a formula column to calculate ‘Days Remaining’ between today and the end of the timeline. This is what we have so far! It is not calculating correctly.
Thank you!
Grace M.
Hello! We are trying to use a formula column to calculate ‘Days Remaining’ between today and the end of the timeline. This is what we have so far! It is not calculating correctly.
Thank you!
Grace M.
Hi @gracemeyer,
If you want to get the number of days until the End of the timeline and 0 if the timeline is in the past, you should use:
IF(FORMAT_DATE(TODAY(),"YYYY-MM-DD")<{Timeline#End},
DAYS({Timeline#End},FORMAT_DATE(TODAY(),"YYYY-MM-DD")),
0
)
What if we could break free of the Formula column? and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.
You’re amazing! Thank you so much.