HELP!!!

Options
image.png

I want to add Invoice Number (105) to Invoice Information that was last queried which is shown as 1 in Last. Please help!

Best Answer

  • Antonie B
    Antonie B ✭✭✭✭✭
    Answer ✓

    @Nicole_Codi17


    I think an Index/Match formula is the answer you are looking for.

    This will return a value based on a value in another column. In your case, it would look like this:

    =Index([INV NO (Query)]:[INV NO (Query)], MATCH(1, LAST:LAST, 0))

    You may need to adjust your column names to make it work. Also, the 0 is to return exact matches only. If you set this to 1, it will return a close match if no exact match is found.

    You can see more information on the functions here:

    Index function: https://help.smartsheet.com/function/index

    Match function: https://help.smartsheet.com/function/match

    Hope this helps

    Antonie

    Implementation Guru @ Invoka

    Smartsheet Platinum Partner

    Smartsheet Core App | Project Management | Brandfolder Certified ✅

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!