I'm trying to keep users from updating a cell until another cell is filled in. I tried using a workflow, but it's not working. Anyone have any experience with this?
Have you tried refreshing your sheet after the initial column is filled in? Sometimes automation don't fire until the data is saved. Let me know if that helps or not, and I can help you dig into it more.
Thanks for your response!!
Yes, I always save and refresh a few times (too impatient to wait for the system).
Here's how I have it set up:
I have a column called "Tech Status" that is locked. I have two workflows set up: 1) enter a value "Ready for Status" when anything changes in a column called "Tech Diagnosis". 2) Unlock the row "Tech Status" when "Ready for Status" is entered.
The first workflow is working, the unlock one is not.
Hmmm. The challenge is that you have to unlock the column not the row. Row unlock locks and unlocks an entire row. You would have to apply that to the entire column. Perhaps a better choice would be to add a formula in the cell so that editors can't edit it. Then use the delete a cell's value workflow.
@Tim Dollmeyer a possible workaround is to use the "Change Cell Value" automation with a condition, that overwrites the "locked cell" with an error message unless the "condition cell" is completed? And second automation to notify if this error message is triggered.
Thanks for your help! I set up a workflow that deletes any input in the status cell if the diagnosis cell is empty. Sneaky, but it works.
@Tim Dollmeyer Awesome. I am glad I could help. Where there's a will there's a way! #creativeSolution for the win!
I am trying to accomplish the same task. @Mike Wilday you mentioned entering a formula that would not allow them to edit the cell and then putting in the automation that clears the formula once the other cells are filled. What formula could I use that would stop someone from editing it?
Hi Steve, you could prepopulate the cell with any formula really... ="N/A" would put the text N/A and then you can use the workflow to clear it once it is needed. You have to make sure that your users aren't admins on the sheet.
I might also be thinking of using a report to facilitate the editors management of their cells too. Editors can't edit a cell that has a formula in it.
We had a Latest Comment column but the Column Type wasn't accurate. Showing as a Text / Number type. I tried to resolve this and I get the error "There is already a Latest Comment column in the sheet". To try to resolve, I created another column and deleted the original. However this still hasn't fixed the issue. There are…
Hi everyone, my colleagues and I are new joiners to smart sheet, we all have pro plan licenses, but when I share a sheet with them with Admin access for each and every one of them they still don't see the Filter CHOICES I added in the Task Bar (to the right of the dropdown for changing the view), any idea why that is? I…
I found out yesterday that Medtronic will not be renewing my contract, as per legal there is a 2 year max on contracts. So I need to transfer my Medtronic Community profile to my personal (free account) I created. Now I bookmarked the link below from before. However I was unaware of what the timeline involved was. Like…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.