Conditional formatting when a change is made
Using our inventory file, we're required to export daily and save on our work server. Our accounting department is requiring that we keep a months worth of adjustments to each individual item with simple + and - formulas (i.e. 10-1-2+2-1). I know that the formulas do not export into excel from smartsheet, but I'm trying to figure an "easy" way to show a change an adjustment has been made to a specific product without adding work to our inventory coordinator. Perhaps a conditional formatting that would highlight some part of the row once a change was made (whatever the change maybe). Then they can adjust the excel file manually.
Help Article Resources
Check out the Formula Handbook template!