Formula Using OR - multiple sheets
Hello - I am using INDEX/MATCH formula to pull dates into a sheet. One particular column is different because the dates can be in one of 2 sheets. What would be the correct formula?
Current formula
=INDEX({3.1 Launched Apps Range 5}, MATCH([Content Name]@row, {3.1 Launched Apps Range 4}, 0)
Tags:
Answers
-
If I'm getting the entire situation here you could check if the first date is blank and then get the other date.
so something like If(isblank(Index(Match#1),Index(Match#2),Index(Match#1))
If both dates are populated and you need both dates then youd need to modify it a bit.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!