If Formula
Samuel Dowdy Jr.
✭✭✭✭✭✭
How would I correct this formula so that if the answer were zero and/or there was an error I would want the cell to be blank?
=IFERROR([Work Performed Total]@row / [Employee Count]@row * 12, "")
Answers

I think you are just missing a bracket/parenthesis
If you do
=IFERROR(([Work Performed Total]@row/[Employee Count]@row)*12,"")
or
=IFERROR([Work Performed Total]@row/([Employee Count]@row*12),"")
Depending on if it is the result of Work performed Total / Employee Count that is multiplied by 12 or just the employee count multiplied by 12…
It should work

It didnt work. I want the cell to be blank if the answer is 0 and/or if the answer is error
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 36 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!