Clear a Cell

Brian_Richardson

Hi- I have a workflow that uses the Update Row action from the Smartsheet integration. I'd like to clear the contents of one cell, if the other cell is blank. I use a "Is Empty" junction to see if the "driving" cell is blank. If it is, then I run Update Row.

The problem is, I can't find a way to clear a cell. If I use the Advanced Cells section of Update Row and put the row and column ID in with a blank value or a space, it just leaves the existing cell value as-is. Is there any magic data reference or something I could use here?

Samuel Mueller

Have you tried double quotes? ""

Brian_Richardson

Ok good call...I can't recall now if I tried that or not. I don't have that workflow any longer but will give it a shot, I appreciate the tip.

Kelly Moore

If the double quote doesn't work, and it probably will, you might be able to insert a phrase in the cell that could trigger the 'Clear Cell Value' sheet automation.

Brian_Richardson

Also a good idea, I always like to accomplish it all within the workflow so I don’t have to remember the combination of workflow and automations etc. But thanks for the tip.