IFERROR

Options

Shannon Lacerda

Shannon Lacerda ✭✭

05/18/21 in Formulas and Functions

I am getting #UNPARSEABLE when I try to add an IFERROR.

0 ·

Best Answer

Shannon Lacerda ✭✭

05/18/21 Answer ✓
Options
@Mark Cronk Thank you that worked

0 · Share on Facebook Share on Twitter

Answers

Mark Cronk ✭✭✭✭✭✭

05/18/21
Options
Try:
=IFERROR(Total@row-total3, 0)
Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
0 · Share on Facebook Share on Twitter
Shannon Lacerda ✭✭

05/18/21 Answer ✓
Options
@Mark Cronk Thank you that worked

0 · Share on Facebook Share on Twitter
Mark Cronk ✭✭✭✭✭✭

05/19/21
Options
Perfect. Glad you found a solution. Thank you for contributing to the Community.
Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Change dot color based on date field
I am trying to come up with a formula that will change a RYG symbol to green if the date in another column is within the first 14 days of a month. The symbol column is already set up with the right column type. Thank you for the help!
VLOOKUP Formula to pull column data into another sheet
I'm trying to match the "Application" # (Table 1) to the "Application Name" (Table 2) and return the corresponding "Primary Product Family" (Table 2, Column 2) into "Program" (Table 1, Column 1) using the VLOOKUP formula, but I'm receiving some of the information and the other information returns #NO MATCH. I want to match…
Formula using Index and Match to reference another sheet only returns first item
I am using an Index/Match formula to lookup a person associated with a specific region. I have a sheet setup as a lookup table named Gift Card Approver with 2 columns: Region and Approver. In my main sheet I have a formula that pulls the region from the current line and uses that to lookup the approver in the Gift Card…