Field locked without being locked?
I'm have a sheet that tracks all the work taking place in my department. I set up an automation so that every Wednesday at 8am a request for update is sent out to every manager who has team members with work assigned to them.
One of the fields that an update is requested for is percent complete. For the past couple months, it has worked great but today the field is locked and cannot be edited in the request for update. The column isn't locked on the sheet it's only locked on the update request.
Any ideas?
Best Answer
-
Just answered my own question. For work that has actual project schedules I'm pulling percent complete from those gantts.
In case anyone reads this and has the same question I had. Linking a cell locks it down and it can't be updated via update request.
Answers
-
Just answered my own question. For work that has actual project schedules I'm pulling percent complete from those gantts.
In case anyone reads this and has the same question I had. Linking a cell locks it down and it can't be updated via update request.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives