IF Formula returning as Unparseable

Jessb9187
Jessb9187 ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

Good afternoon everyone,

I am having a heck of a time trying to figure out why my formula keeps returning as #unparseable.

If a Category says Expedite, the cell needs to show $25.00, if not, it needs to show $0.00. My formula isΒ =IF(Category1 "Expedite", $25.00, $0.00).Β 

I've tried removing the dollar signs, the decimals, and I can't get it to work for me. What am I missing here?

Β 

Comments

  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭

    Try

    =IF(Category@row = "Expedite", 25, 0)

  • Alison
    Alison Employee

    Hi JessB,

    Β 

    =IF(Category1 "Expedite", $25.00, $0.00). is your original formula, and it looks like you're missing the first punctuation after Category1, and you'll want to put quotation marks around the values to input into your sheet.

    Β 

    I think you'll want to do this:

    Β 

    =IF(Category1 = "Expedite", "$25.00", "$0.00")

    Β 

    I tested this out and it works in my sheet.

    Β 

    However, if you find that the above formula does not work, I found that copying and pasting it from this Community post gives you the #unparseable error.Β 

    Β 

    As a result, please try typing out exactly what I've typed above instead of copying and pasting it to see if this helps.

    Β 

    You can also use what nlarsen suggested by substituting Category1 for Category@row.

    Β 

    Alison

    Screen Shot 2019-01-29 at 08.20.14.png

    Screen Shot 2019-01-29 at 08.20.17.png