Nesting IF Formula
I have been reading though the discussions and have attempted to nest the IF functions but I am having difficulties with it maybe someone will be able to help me. We are using check boxes to track numbers when checked. I created the function and got it to work.
=IF([PRHT Wrap Claimed]10, 10, 0)
The issue I am having is, we N/A the cells when they are not being used so they are not accidently checked. This of course creates a #INVALID DATA TYPE ERROR. I have made multiple different attempts to make it so a N/A is equal to zero but I am not having any luck. I am thinking I need a nested IF formula but I am not for sure. Formulas are not my strong suite sadly. Any help on this would be great
Comments

Try wrapping the IF statement in an IfError...
=iferror(IF([PHRT Wrap Claimed]10, 1, 0))

Thanks Mike, I attempted to put in the formula you suggested and it came up as #UNPSARSEABLE. Any other ideas?

Well, it looks like I misspelled your column name. This one should do it.
=iferror(IF([PRHT Wrap Claimed]10, 1, 0))
I keep this link on hand when working with formulas in Smartsheet.
https://help.smartsheet.com/articles/2476176formulaerrormessages 
When I was reading through your earlier post I had noticed the typo and changed it when I was originally trying your formula. I tried the new one you posted above with the fix and it still isn't working.

hmmm. can you post a screenshot of the data again with the new formula?

Here you go. I had to move the formula down to row 13 due to data input.

I see the problem. You have a 10 in there instead of 1. Delete that zero and you should see it working properly.
What you have: =iferror(IF([PRHT Wrap Claimed]13, 10, 0))
What it should be: =iferror(IF([PRHT Wrap Claimed]13, 1, 0))
What do you get when you update that?

I'm still getting the unparseable.

I see some other potential errors here. What should be the result if the Wrap is checked? If the wrap = 1 then what should the result be?

When it's checked it equals 10. The original formula I have for that works, you can see it above line 13 in the pict I posted today.

=iferror(IF([PRHT Wrap Claimed]13 = 1, 10, 0)," ")
Try this one.

That one does not work either.

Hmmm. I am not sure what is going on. I have attached a couple screenshots to show you that it is working on my end. This should be completely unattached to anything else. The formula doesn't even throw an error when N/A is in the checkbox field, cause your just checking to see if its a 1.
I have it working with  and without  the IFERROR. There must be something else going on...
See animated gif below.

Apparently it was due to the fact I was copying and pasting the formula in. I typed it in and now it is working. Sorry about the extra steps.
Thank you for all of your help on this this will make tracking our information a lot easier!

You're welcome.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.8K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!