Can I do a cell link with an absolute?

minh.h.nguyen

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.

KPH

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

minh.h.nguyen

KPH, thanks! Can I autofill cell linking?

KPH

Sorry @minh.h.nguyen I don't understand the question.

Andrée Starå

Hi @minh.h.nguyen

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!

minh.h.nguyen

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.