Can I do a cell link with an absolute?
How can I cell link but have the information stay in the exact cell I pull from when the data gets upadated? For ex
the bottom sheet is the information i want to pull from. Column RDC, row 1 is the value I want in that cell to return to the top sheet every time the bottom sheet gets updated no mater the information in that cell.
Answers
-
I am not quite sure I understand what you need, but it sounds like cell linking could be the answer. Have a look at this:
https://help.smartsheet.com/learning-track/level-2-intermediate-users/cell-linking
-
KPH, thanks! Can I autofill cell linking?
-
Sorry @minh.h.nguyen I don't understand the question.
-
I hope you're well and safe!
You can't autofill cell-links, but you could use formulas instead.
Would that work/help?
Can you describe the use case?
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.
-
HI Andree,
What formula could I use to pull data from another sheet when certain criteria are met? If I want to pull the value in the SCAC column, row 1, to another sheet, What would be the formula? And only pull if that value is CFAA.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!