Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

return a blank when #divide by zero

Si Spence

Si Spence ✭✭✭✭✭✭

05/31/17 edited 12/09/19 in Archived 2017 Posts

friends, is there a quick n easy way to return a blank in a cell instead of #divide by zero

pls see screenshot. ta, Si.

0 ·

Comments

Shaine Greenwood Employee

05/31/17 edited 05/31/17

Wrap your formulas in an IFERROR function: https://help.smartsheet.com/function/iferror

You can set the value_if_error to "" which will return blank.

0 · Share on Facebook Share on Twitter
Si Spence ✭✭✭✭✭✭

05/31/17

Thanks Shaine, It's easy when you know how!

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Using Nested If and Formula to Set Value of Field
I'm trying to set the value of a field using an IF statement based upon a calculated number in a column called "Tier Score". =IF ([Tier Score]@row <= 17, "Tier 3", IF ([Tier Score]@row <= 25, "Tier 2", IF ([Tier Score]@row >= 26, "Tier 1"))) I keep getting UNPARSABLE. Thanks
Add to INDEX formula to account for blank cells?
I have a mapped column that displays a Contact based on what's inputted in another cell. E.g. Slim J = Slim Julian. Here's the formula: =INDEX({PD - NetSuite Name Mapping USE Range 1}, MATCH([PDS Selected]@row, {Formstack Name}, 0)) However, if the cell is blank, it just assigns the first Contact alphabetically, even…
Template with Dynamic view and Control Center
One of our templates relies on dyanmic view. Will the settings for Dynamic View stay in place when new project is created? All projects are created using Control Center. I've already searched in the Community, looked a articles, and learning.