Is this the right formulas for Expiration Dates?

Options

=IF([Land Owner/Tenant]@row = "Owner", IF(OR([Replacement Closing Date]@row <> "", [Replacement Eligible?]@row = "No"), "", IF(OR([Buyout Closing Date]@row <> "", [Vacancy Inspection Date]@row <> ""), MIN(IF([Buyout Closing Date]@row = "", 99999999999999, [Buyout Closing Date]@row), IF([Vacancy Inspection Date]@row = "", 9999999999999, [Vacancy Inspection Date]@row + 365)), IF(OR([Replacement Closing Date]@row <> "", [Replacement Eligible?]@row = "No"), "", IF([Vacancy Inspection Date]@row = "", "", [Vacancy Inspection Date]@row + 365)))))



Thank you!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!