How do I write a formula/function that uses whichever scenario is earliest?
I have a sheet with two optional dates.
Something happens 45 days from the date something was received
or
Something happens 145 days from the date of an incident
Example. An incident occurs, and materials must be submitted. We then have to write a report within 45 days of the date the materials were submitted or within 45 days after 100 days post-incident (145 days total), whichever date is the earliest.
I believe it would be an if this or that statement, but how do I say whichever is the earliest date?
Answers
-
Do you already have formulas for the two separate dates? Have you looked into the MIN function?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!