Formula to return a label based on number of days past

Platform discussions
,
1

I am looking for a formula to return a result after a certain number of days have past. This seem pretty simple, but I can’t seem to get it to work.

Use example
3 years after a date in a date column set the formula to report “retake due”

I think the formula format will also work on another board
When an inventory drops below a certain value set result to “time to order”

Thanks for the help!

2

@JRooney

This is a pretty simple formula:

IF(YEARFRAC(FORMAT_DATE({Date}), TODAY()) >= 3,"retake due", "")

For the second one, something like this:

IF({Quantity} <= {Reorder Qty}, "time to order", "")

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday

1 Like