Prioritize by available date

I have a sheet that has multiple dates on a row, but not all will be known at the same time. Iβm looking for a function or a way to provide the current best estimated date by priority. Basically, if there is a date in this column, use it, if not, use this other column, and if nothing is in either, use the date from this other column. Iβve been trying to work on this with an If function, but Iβve gotten stuck at only one level of priority. The below formula in my βDate for Chartβ column has gotten me to get βactual arrival dateβ if βinvoiced dateβ is empty. But Iβm getting stuck trying to get the result if they are both empty to choose the next level of priority, and so on. Do you have any advice for this?
=IF(NOT(ISBLANK([INVOICED DATE]@row)), [INVOICED DATE]@row, [ACTUAL ARRIVAL (DELIVERY) DATE]@row)
Best Answer
-
You would use a nested IF where IF #2 goes in the 3rd portion of IF #1, IF #3 goes in the 3rd portion of IF #2, so on and so forth.
=IF([This Date]@row <> "", [This Date]@row, IF([That Date]@row <> "", [That Date]@row, IF([Another Date]@row <> "", [Another Date]@row, .................................))))
Answers
-
You would use a nested IF where IF #2 goes in the 3rd portion of IF #1, IF #3 goes in the 3rd portion of IF #2, so on and so forth.
=IF([This Date]@row <> "", [This Date]@row, IF([That Date]@row <> "", [That Date]@row, IF([Another Date]@row <> "", [Another Date]@row, .................................))))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!