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?
Thanks, Kyle