INDEX/MATCH results when sheet moves to archive

Hi everyone - I'm running up against an issue: I've created an index/match formula to pull in a date when an invoice is processed from another sheet. That worked great until my workflow moved the row to an archive sheet. Now the INDEX/MATCH is showing #NO MATCH in the date field.

Does anyone have an idea for a workaround on this?

Thanks in advance!

Answers

  • AravindGP
    AravindGP ✭✭✭✭✭

    Hi,


    You will have to look up the value in both the main sheet and the archive sheet. You can do this by using an IFERROR formula. Do an index/match as the main formula with the error formula referencing to the archive sheet

    Thanks,

    Aravind

    Reach out for any help on licenses, configuration, or training

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!