Iferror query

vipa2000

Hi, I was getting a divide by zero error on certain fields so introduced the following into a calculated cell...

=IFERROR(([Outstanding CCTV validation?]@row / [CCTV Validation Total]@row) * 100, "No data to allow calculation")

At first I thought it was ok but when I get 1/1 for each cell - Outstanding CCTV validation? and CCTV Validation Total respectively and then x 100 I get the same answer - "No data to allow calculation"

Obviously doing something really daft! Reading the smartsheet exemplar didn't help. Thanks in advance.

vipa2000

Spent 20 minutes going around in circles with this. Solution - hit save! I had been dragging field down and getting "No data to allow calculation in all fields". When save hit, refreshes correctly. Doh.

vipa2000

Spent 20 minutes going around in circles with this. Solution - hit save! I had been dragging field down and getting "No data to allow calculation in all fields". When save hit, refreshes correctly. Doh.

Andrée Starå

Hi @vipa2000

Excellent!

Happy that you got it working!

Be safe and have a fantastic week!

Best,

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

✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!