Formula Column - Multiple IFs

Platform discussions
,
1

I am using a Formula column that looks at a specific status column and depending on the value it will return specific text for each value.
I’m having trouble getting it to work correctly even for just one value.
IF({Status }=“status 1”,"
",“status 1 text”)
This gets me status 1 text in every cell in the column. Not just for those that have the status value of “status 1”.
Any hints on how to correct this and then to also have it look at the rest of the values as well and assign text>

2

Hey @cgaffney, if you want to use the formula column to output a text value deepening on the status, here is how:

Solution
Your title mentions wanting to use multiple IF statements in the same formula column, I’ll show you how to do that as well.

  1. This is the basic setup I have here. Below shows what the output of a formula column is by exactly reflecting the output of the status column. I find it’s a helpful place to start to figure out what is going on with any issues that occur.
    image
    image505×231 8.02 KB
  2. Let’s start with one IF statement. “If status is ‘Done’ output success, otherwise output NA” → IF({Status}=“Done”,“Success”,“NA”)
    image
    image643×176 7.66 KB
  3. Now we can start implementing multiple IF statements. “If status is Done output success, otherwise IF status is ‘Working on it’ output In Progress, otherwise output NA” → IF({Status}=“Done”,“Success”,IF({Status}=“Working on it”,“In Progress”,“NA”))
    image
    image786×185 9.86 KB

    Note: You can format the formula column with new lines and tabs so it’s easier to understand as you build it.
  4. For our last IF statement. “If status is Done output success, otherwise IF status is ‘Working on it’ output In Progress, otherwise IF status is ‘empty’ output Waiting on start, otherwise output NA” → IF({Status}=“Done”,“Success”, IF({Status}=“Working on it”,“In Progress”, IF({Status}=“Empty”,“Waiting on Start”, “NA”)))
    image
    image821×197 12.4 KB

Hope this was helpful. If this fixed your issue please mark this as the solution. Otherwise reach out and I’ll try help more.

All the best,
Nathan Kind
Lead Software Consultant | Kinder Tech

1 Like
3

Thank you so much Nathan! This totally works.

Cindy

4

@cgaffney you are very welcome! Would you kindly mark that as the solution to help other people find the same answer and give me some credibility in the community.

5

Perfect solution thank you! @kindertech