Using a Flag column to identify associates that are on another sheet.


I'd like to create a formula to vlookup a cell value from a separate smarsheet and if that associate is on that sheet, instead of pulling back #NO MATCH, and the cell value if it is on the other sheet, I'd like for it to flag an associate if they are on the list. So I'd like that column in my main sheet to be a flag or checkbox column and only if they are on the separate list, it will flag or check the box.

Any help is appreciated😀


  • Brent Wilson
    Brent Wilson ✭✭✭✭✭


    A quick one might be to flag those that do not exist on the sheet rather than flagging those that do

    Have a look at the IFERROR and ISERROR Functions

    something like =IFERROR(Your Vlookup Statement, TRUE)

    would put a flag or check a box in a checkbox column if it did not exist

    I think below would put a Flag where your vlookup worked

    =IF(ISERROR(YourVlookup), False, True)

    Brent C. Wilson, P.Eng, PMP, Prince2

    Facilityy Professional Services Inc.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!