IFERROR

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 ✓

@Mark Cronk Thank you that worked

0 · Share on Facebook Share on Twitter

Answers

Mark Cronk ✭✭✭✭✭✭

05/18/21

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 ✓

@Mark Cronk Thank you that worked

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

05/19/21

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

Calculate Number of Class Sessions between a Start and End Date
I've tried many variations of formulas, but I am getting #INCORRECT ARGUMENT SET every time. [Session (Days)]: Dropdown box, multiselect, days of week (e.g., "Tuesday", "Monday and Wednesday") Session Meeting (Start Date): Date column, enter start date of course (e.g., 2/11/2025) Session Meeting (End Date): Date column,…
IF state with 3 sets of criteria
Hello, I am struggling to get my IF formula to give me anything other than #UNPARSEABLE I am creating an inventory sheet where if "Stock qty" column is less than "Reorder level" qty than to return "REORDERED NEEDED" or if it is greater than reorder level than to put "OK" but the tricky part comes when I add in my third…
Identify matching apps with date conflicts and print out "conflict"
The general idea is I have a sheet where we list each effort and the application it impacts (column "Application") as well as the dates the Code is going to be in my QA environment. I'm trying to create a formula that checks when the "Application" values match and if so compares my date range [code drop date to end prod…