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.
Using Approvals with a formula cell
I am trying to use an approval request to change the value of a cell that contains a formula. The cell that has the formula is based on data in two other cells. For example, the other two cells can either be "Yes" or "N/A". If both of them are "N/A", then my approval cell automatically changes to "Yes" and it does not generate an approval request. If either or both of the cells are "Yes", then it changes to "Submitted" and sends an approval request. The problem is my approval request does not overwrite the formula, so the cell does not change. Is there any way to get around this?