Formula not updating


I have a very simple formula. =[Unit Price]@row * Units@row. It is suppose to take the unit price cell in the row and multiply it by the units cell in that same row. 9 times out of 10 it works fine, but every once in a while it wont update. This is causing us invoicing issues within out company as we have to go back and update the units at the end of the job. if it isn't done correctly we don't bill correctly.

has anyone else had this issue and is there a fix for it?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!