Dragging a formula - Please help
Hi there,
I am trying to change text cell values from one form survey results to number values on another sheet that I can then report on & manipulate better with numbered values.
I can't figure out how to update the formula references so that they dynamically update when dragging down the column. When I link to a cell in a specific sheet the IF formula works but when I drag it down, the formula still references the initial cell link. When I linked to the column, the IF formula returns an invalid error. Would someone be able to assist me with this please?
I have 37 columns in the report so really hoping I don't have to manually type a new formula for each. Please see pics below if helpful at all.
Answers
-
Hi @EimearC
I hope you're well and safe!
Have you explored using a VLOOKUP formula instead?
Would that work/help?
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks for your response, much appreciated.
Regardless of the formula used, I still need to drag it down & across to update rows & columns. Does a vlookup formula automatically update the references ranges whereas an IF statement will not?
Thank you for your assistance,
Eimear
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!