Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Date Formula Issues (For Warranties)

Topic Labels: Formulas
413 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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