Hi - yes! You can. There’s an action formula =UPDATECELL(). If you do =UPDATECELL(cell_location, “ ”), then you will reset the value of that cell to be blank again. If you want this to only happen when a value is met you can do =IF(cell_location = "value", UPDATECELL(cell_location, “ ”)) You can then automate this action column to reset the statuses on a schedule. Let me know if that works, or if you have further questions! If you'd like to hop on a support call, you can schedule one here: calendly.com/ben-lido/building-session-andres
Hello
Is there a way to clear the status field if a value is met?
Hi - yes! You can. There’s an action formula =UPDATECELL().
If you do =UPDATECELL(cell_location, “ ”), then you will reset the value of that cell to be blank again. If you want this to only happen when a value is met you can do =IF(cell_location = "value", UPDATECELL(cell_location, “ ”))
You can then automate this action column to reset the statuses on a schedule. Let me know if that works, or if you have further questions!
If you'd like to hop on a support call, you can schedule one here: calendly.com/ben-lido/building-session-andres