Formula question :)

Options
Whitney Davis
Whitney Davis ✭✭
edited 06/08/22 in Formulas and Functions

I am trying to pull content from 2 existing sheets into a new sheet that will have additional manually editable columns. The formula that I am currently playing with isn't work, but looks like this:

=IFERROR(INDEX({Type}, MATCH([EventID#]@row, {EventID}, 0)), INDEX({Event Location}, MATCH([EventID#]@row, {NOEventID}, 0))

Basically I am working off of autopopulating some of the cells in the row based off of the eventID's from 2 different sheets.

Thank you in advance!

Tags:

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Options

    Hey @Whitney Davis

    When you say the above formula isn't working, please describe. Is it not returning the expected data or are you receiving an error? IF you are receiving an error, what error? Is the IFERROR there to redirect in the event of NoMATCH?

    Kelly

  • Whitney Davis
    Options

    Hi @Kelly Moore ,


    I am getting an error message with that formula. "#UNPARSEABLE" is the error message I am getting. I am trying to build a sheet that pulls from a primary sheet and then if there is no data on the primarty sheet to pull from the secondary.


    Thank you for your help, I am fairly new at SmartSheet.

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Options

    Hey Whitney

    You're missing the last parenthesis to close the IFERROR. Look at your last parenthesis in your current formula. My guess is it is pink instead of blue. Add one more

    =IFERROR(INDEX({Type}, MATCH([EventID#]@row, {EventID}, 0)), INDEX({Event Location}, MATCH([EventID#]@row, {NOEventID}, 0)))

    Does this work for you?

    Kelly

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!