Reset a Row

SYDPEN

Hello,

I am looking for a way to have certain cells in a row "reset" once a checkbox (in that same row) is checked. When I say "reset", I want two cells to go back to being empty and another cell to have an updated quantity.

Is there a way to do this? Maybe multiple automations?

Appreciate any help or ideas!

Jeff Reisman

@SYDPEN

You can clear or change multiple columns in a single action, so you just need one automation to clear the two cells.

The problem is updating the quantity. You can't use change cell actions to set a dynamic value like an updated quantity. So you'd need to use an IF in the quantity column in order to set a different formula based on whether or not the checkbox is checked.

Andrée Starå

Hi @SYDPEN

I hope you're well and safe!

How would the updated quantity column need to work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SYDPEN

https://community.smartsheet.com/discussion/comment/328183#Comment_328183

Thank you Jeff. I was able to set up the automation to clear the cells and I have an equation from a previous sheet

=IF(ISNUMBER([QUANTITY CLAIMED]@ROW), [STARTING QUANTITY]@ROW - [QUANTITY CLAIMED]@ROW, [STARTING QUANTITY]@ROW)

I know this formula works at reducing the Available Quantity column when a number is inserted into the Quantity Claimed row, but how could I integrate whether or not the checkbox is checked?

Appreciate all the help!

Jeff Reisman

@SYDPEN So you can't use automation to set a formula into a cell. But you can use an IF formula to switch between different formulas for that cell depending on criteria. The syntax would be something like this:

=IF(CheckboxColumn@row = 1, formula you want used if it's checked, formula you want used if it's not checked)

If you want multiple criteria to be considered, you can use AND or OR around multiple logical statements at the start of an IF:

=IF(AND(CheckboxColumn@row = 1, ISNUMBER([Quantity Claimed]@row), formula you want used if it's checked and Quantity Claimed is a number, formula you want used if it's not checked and no number is in Quantity Claimed)