How to use VLOOKUP for columns with indentation?

shubhangia

shubhangia ✭

09/20/21 in Smartsheet Basics

Hi, I am not able to use VLOOKUP on the column which has indentation in another sheet, is there a way out I can search and match in the column with indentation

0 ·

Answers

Paul Newcome Community Champion

09/20/21

You should be able to. Exactly what are you trying to do? Are you able to provide screenshots for reference?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

how do you freeze a full work sheet
Prefill a form response from another sheet
I have a project tracker sheet and am trying to set up a flow to send a survey via a form once the status of the project is changed to complete. I would like the survey to prefill with the project name from the source sheet, of the project that was changed to closed. Is this possible? The form results (survey results)…
Can you preserve password protection in .pdfs that are attached to a form submission?
My colleagues need to submit Smartsheet forms with password protected .pdfs attached. The form submissions are being received as expected, and you can see the attachment in the proper row but when you go to open it (either directly or after downloading), an error message pops up, "We can't open this file. Something went…

Help shape the future of Smartsheet.
Share your ideas and feature requests.