Is this the right formulas for Expiration Dates?
=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
-
You are going to need to provide more context. What is the expectation for how the formula is supposed to work , and are you able to provide a screenshot for reference?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!