Changing a cell value to blank using Change cell value automation

Lisa Vercellone

We use SmartSheet in our boarding process. Sometimes sheets get voided. When that happens, I want to be able to reset the status of completed tasks to blank so that they show up as new tasks that need to be completed on our reports. I use the change cell value automation a lot but I can't figure out how to change the cell to blank. Any ideas?

Thanks, Lisa

Paul Newcome

I haven't figured out a direct way, but you can use a helper column with a SUBSTITUTE function to replace whatever is populated by the automation with a blank and then only display this helper column.

Lisa Vercellone

I do not think the helper column is feasible for our situation. I think I'll try adding another status to indicate the task needs to be "undone". Hoping change cell to blank will be in the near future!

Thanks, Lisa

Aider

The latest workflow version have the option to clear cell value