Re: If statement for multiple non-value fields

Solved
1087 0
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

I have 5 non-value fields that indicate if a person has paid an application fee or not. The fields are:

180 GBP, 210 GBP, 240 GBP, 270 GBP, and 300 GBP. If a person has paid, it will say "Completed" under the column that they have paid. It will say "Not Started" if they have not paid.

For example: If person A has paid the fee of 240 GBP, it will say "Completed" under that column, and it will say "Not completed" under all of the other monetary columns. (it was not my idea to organise it this way, it is just the way it has to be!)

I would like to add a formula field called "Paid" that can identify if a person has paid (Yes or No) based on the statuses of the 5 monetary value columns. I want it to recognize that if 1 of the columns in a row is "completed" that the "Paid" value will be "Yes."

Does anyone know if this is possible? Please see photo attached for an example of how the fields are laid out, and a sample "paid" field.

1 Solution

Accepted Solutions
12 - Earth

The quick and dirty nested IF-formula:

``IF({180 GBP}="Completed", "Yes", IF({210 GBP}="Completed", "Yes", IF({240 GBP}="Completed", "Yes", IF({270 GBP}="Completed", "Yes", IF({300 GBP}="Completed", "Yes", "No")))))``

it was not my idea to organise it this way, it is just the way it has to be!

Ok, I'll let this one slide then 😬😅

4 Replies 4
12 - Earth

The quick and dirty nested IF-formula:

``IF({180 GBP}="Completed", "Yes", IF({210 GBP}="Completed", "Yes", IF({240 GBP}="Completed", "Yes", IF({270 GBP}="Completed", "Yes", IF({300 GBP}="Completed", "Yes", "No")))))``

it was not my idea to organise it this way, it is just the way it has to be!

Ok, I'll let this one slide then 😬😅

5 - Automation Enthusiast

I have been messing around with nested formulas for about an hour and it warms my heart knowing that what I had recently written was actually close to the formula you provided above (Which worked perfectly).

Thank you so much! Working with someone else's data organisation can be a bit interesting sometimes 😅

12 - Earth

My pleasure! Don't forget to mark my answer as the solution, so others can also find it.

12 - Earth

Hi,
Other way to accomplish the task. Will not work if somebody turn other option to 'Not Completed'

``IF(FIND('Completed',{180 GBP}&{210 GBP}&{240 GBP}&{270 GBP}&{300 GBP}), 'Yes', 'No')``