Help with Date Formula

Options
WinaHath
WinaHath ✭✭✭✭
edited 08/08/23 in Formulas and Functions

I need help with this formula, please.

I need to get the PO date from this sheet

and output that date to this sheet


I tried this formula but it is not working:

=IFERROR(INDEX({PO Date}, MATCH([Vendor Name]@row, {Vendor ID#}, 1)), "")

Both columns are Date fields

Thank you!😀

Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Options

    Hi @WinaHath,

    Your formula makes it look like you're trying to match the Vendor Name with the ID # on the other sheet. Should your formula be more along the lines of something like this?

    =IFERROR(INDEX({PO Date}, MATCH([Vendor ID #]@row, {Vendor ID#}, 1)), "")

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!