Can I Automate entering/erasing data from a cell?


Is there a way to set up an automation so the content of a cell can be changed when one or more criteria is met? I have a sheet where I'd like the cells in a particular column to be cleared at a certain time everyday. Is this possible?



  • Sean Morgan
    Sean Morgan Employee
    edited 11/06/20

    Hello @Lindsay P. ,

    As of now, we do not have a dedicated method of automatically removing data based times. With this, you may wish to raise an Enhancement Request, and may see this in a future release of Smartsheet!

    You may wish to use something like Data Uploader if you are going to automatically update these cells with new data.

    Although I'm unable to confirm this, it may be possible to clear the contents of a Column using a third party app such as Zapier

    Let me know if you have any questions



  • L_123
    L_123 ✭✭✭✭✭✭

    You can do this with a move workflow and some time parsing. It would be a fairly complex solution that would require 2 sheets. I wouldn't recommend it if you aren't an advanced user, but if you want some more detail I would be happy to help.