How can I use the lookup formula in the Smartsheet

PreethamG

I have smartsheet and I want that sheet to get the data populated from an excel sheet, how do I use the formula. Is there any way?

mapotter.sailpoint

You have index match and vlookup in smartsheet. The information will need to be in your smartsheet in a sheet. I would pull the information from your spread sheet into smartsheet with the import from excel.

Smartsheet does have functionality with a couple of add on features data mesh and data shuttle that may be helpful. You can look up information on these addons in the Help & Learning space.

Andrée Starå

Hi @PreethamG

I hope you're well and safe!

Is it a one-time thing to get information over from Excel to Smartsheet, or do you want to keep Smartsheet updated with details from Excel?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

PreethamG

Hi @Andrée Starå At the moment I want only one-time transfer.