Help

Nested If Date function

1241 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jennie_Patterso
4 - Data Explorer
4 - Data Explorer

I am making a template to keep track of when our fleet vehicles plates expire. I want to put a function that will warn me of any expired plates but also warn me of when plates are coming due (example…tell me when plates will expire 1 month from today).
Please help. I do not know how to write this formula.

1 Reply 1

@Jennie_Patterson Maybe something like this:

Alerts

IF(DATETIME_DIFF({Date due},TODAY(),‘d’)<0,“ :stop_sign: :stop_sign: :stop_sign: Expired!!”,IF(DATETIME_DIFF({Date due},TODAY(),‘d’)<30,“ :warning: :warning: :warning: Due within 30 days”,BLANK()))