Cell Linking
Is this possible to do....
- I want to have a master call log for incoming service requests, with a status column. I will set an automation to copy the row to another sheet I will use for task tracking.
- Once I have completed the task and change the status on the 2nd sheet, I want to cell link so it also changes on the master log. The caveat is, once I have completed the task, changed the status and saved it, I will no longer need this row on the 2nd sheet. So, once the status is changed, I want that linked back to the master log, then that row on the 2nd sheet to go away.
- is this possible to do????
Thanks!!!!
Answers
-
Are you deleting the rows from the second sheet? or are you moving them to like an archive sheet?
The cell linking part is easy using cross sheet formulas but once the row is deleted from the second sheet it would cause an error in the formula I believe. If it were moved to an archive sheet instead you may be able to set it to link to that sheet instead.
There may be another way to do it that I am not aware of.
-
I could use an archive sheet. I just need it gone from the 2nd sheet once I’m done.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!