Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

duplicate values

HI

 

I have a project for procurement products

I want to make an highlight the row if the same data is available in some other sheet.

 

Can some one help me.

 

Comments

  • JamesR
    JamesR ✭✭✭✭✭

    Slva,

     

    Shartsheets cannot interigate other smartsheets.  You can now do a Lookup within a sheet but not accross sheets.

     

    Sorry I cannot be of more help, but until Smartsheet develop the Vlookup formula using data from other sheets this is not possible.

     

    If you have the Enterprise version you could use the ODBC connector to create two connected spreadsheets and do the lookup in Excel.

     

    James

This discussion has been closed.