Help

Date Formula Issues (For Warranties)

Topic Labels: Formulas
599 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Blu3bird
4 - Data Explorer
4 - Data Explorer

I’m trying to set some automation for warranty dates that if there is nothing selected it leaves it blank. But if the warranty drop down is selected it will read whats in the Warranty Start Days and apply the correct length of time to the date for the expiration date.

Other than googling I don’t have much experience with coding. Sorry. Thanks for any guidance

IF(Warranty=BLANK(),BLANK(), 
IF(Warranty= 1 Year), DATEADD({Warranty Start Date}, 365, "day") 
IF(Warranty= 2 year), DATEADD({Warranty Start Date}, 730, "day") 
IF(Warranty= 3 Year), DATEADD({Warranty Start Date}, 1095, "day"))
0 Replies 0