Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Automate a cell to clear
I am creating a database for researchers to borrow equipment. We want as much of it to be automated as possible.
When an item is marked as 'returned', a green RYG ball shows up in the availability column. I would like other cells to clear automatically in the row when the green ball activates. How can I write a formula so that the name and email of the researcher who returned the item is cleared from the cells?