Help with Date Formula

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!😀


  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    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!