Formula not updating

Chris Wolfe · 03/17/21

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?

James Vandezande · 03/18/21

Is the problem that the formula isn't populating on some rows? If so, I would suggest converting it to a Column Formula. If that's not the issue, I'm not sure what could be causing some rows not to update.

Andrée Starå · 03/18/21

Hi @Chris Wolfe

I hope you're well and safe!

To add to James’s excellent advice/answer.

Is it a large sheet with many thousand rows?
Is the sheet formula heavy in general?
Do you get an error message?

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Chris Wolfe · 03/18/21

https://community.smartsheet.com/discussion/comment/284036#Comment_284036

Andree,

There are about 7000 rows on the sheet, only 5 columns with formulas, and no error popped up.

Chris Wolfe · 03/18/21

https://community.smartsheet.com/discussion/comment/284024#Comment_284024

The formula is in the row and has been but when someone changed a the units cells the total price cell that multiplies unit by unit price did not update.

Andrée Starå · 03/19/21

@Chris Wolfe

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Formula not updating

Answers

Help Article Resources

Categories