Remove Cell Link Automatically
Is there a way to remove a cell link automatically (with a workflow or otherwise)?
I built a time sheet in Smartsheet that automatically pulls in a manager's list of direct reports from another Department sheet when their name is entered into the manager cell. Once they fill out the sheet I'd like to automatically remove the cell link so that those reports are frozen as they are instead of changing when the Department sheet is updated.
Answers
-
Bridge can remove cell links, but if you don't have Bridge then no there's not a way to do this. Typically to "freeze" or snapshot data it's best to do a row copy to another sheet to use as history.
Instead of using cell links, you might instead want to use JOIN/COLLECT formulas to read the data in. You can set criteria on the row that flags when the sheet is filled out, so that the JOIN/COLLECT stops pulling data.
ie something like
= IF ( [Sheet Completed?]@row = false , JOIN( COLLECT( {Direct Reports} , {Manager}, Manager@row), CHAR(10) ) )
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.8K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 510 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- I have a project intake sheet with an automated email to me whenever a new project is submitted. It was working and now it's not, and I'm not sure why. Here's a snapshot of the automation: I am receiv…
- Hi! When I send a request for approval, the customer receives it, and they open the request. How do I tell SS to open a form instead of the SS. Is this automatic?
- Hello Everybody, My team and I use the CopyRow Automation for project intake. Instead of using a form that feeds into a sheet, we manage two separate sheets: One for each of my team members (source sh…
