Formula Using OR - multiple sheets

Options

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

  • markkrebs
    markkrebs ✭✭✭✭✭✭
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!