Help

Re: Basic IF statement question from noob

1378 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Chris_Forster
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi - super basic formula question. Much forgiveness please :pray:

So I have a bunch of tasks listed in a base as rows, with one column being “status” that has various dropdown options, including one called “Done”. I’d like the formula to return a 1 when the status “Done” is true and a 0 when it’s false. I have this:

IF(Status=Done,1,0)

But I get angry red text telling me to try again. I’ve tried with spacing, quotation marks, tried to look up more on IF statements, but can’t see what is probably a very simple mistake. Might be the late hour.

Lil’ help?

Thank you!
C

5 Replies 5
AlliAlosa
10 - Mercury
10 - Mercury

You should have quotes around the word “Done” :slightly_smiling_face:

IF({Status} = "Done", 1, 0)

*Note: The squiggly brackets are only needed if the field name has spaces or special characters, but I like to use them in every formula for ease of distinction between field name references and other values.

Chris_Forster
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you! Works great! +10 karma points
C

Ah, quick follow up. I have used the above to relate to another formula that I would like to show as a percentage. Is there a way to ask the fields to be presented in percentage format? Thanks, Neads!

Many fields have an often-overlooked tab labeled “Formatting” in the field setup dialog. Airtable will give you options that match the output your formula generates.

Of course! Completely forgot about that!
Much obliged.
C