How to write nested IF statement with equals for text?

Question

How to write nested IF statement with equals for text?

Devon Goble 0

I have an online form on our website that clients complete, the it flows into the SP database. I have numeric fields working with IF statements to triage and score them. I am needing to do the same with my "Reason for Call" field.

This is what I tried to write and the syntax obviously failed.

=IF([What Assistance Are You In Need Of?]=Transitional Housing,"10",IF([What Assistance Are You In Need Of?]=Rent,"7",IF([What Assistance Are You In Need Of?]=Utilities,"5","3")

Xyza Xue_MSFT 30,241 Reputation points Microsoft External Staff

2023-01-12T02:33:02.16+00:00

Hi @Devon Goble,

Thank you for your question.

We are currently looking into this issue and will give you an update as soon as possible.

Thank you for your understanding and support.

1 answer

Your answer

Xyza Xue_MSFT 30,241 Reputation points Microsoft External Staff

2023-01-12T02:33:02.16+00:00

Hi @Devon Goble,

Thank you for your question.

We are currently looking into this issue and will give you an update as soon as possible.

Thank you for your understanding and support.

Answer 1

Xyza Xue_MSFT 30,241 Microsoft External Staff

Hi @Devon Goble ，

You need to create a calculated column using the following formula:

=IF([What Assistance Are You In Need Of?]="Transitional Housing","10",IF([What Assistance Are You In Need Of?]="Rent","7",IF([What Assistance Are You In Need Of?]="Utilities","5","3")))

User's image

The effect achieved is as follows:

User's image

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Xyza Xue_MSFT 30,241 Reputation points Microsoft External Staff

2023-01-16T01:19:50.3933333+00:00

Hi @Devon Goble ，

Have you tried the solution I proposed?
If you have any questions or progress, you can contact me in time.
Looking forward to your reply
Have a lucky day!
Thanks,
Haoyan Xue

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Xyza Xue_MSFT 30,241 Reputation points Microsoft External Staff

2023-01-18T08:20:29.5333333+00:00

Hi @Devon Goble ，

I am checking the status of this case. Please let us know if you would like further assistance.
If you have any update about this issue, please feel free to post back.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Xyza Xue_MSFT 30,241 Reputation points Microsoft External Staff

2023-01-30T02:14:35.3+00:00

Hi @Devon Goble ，

I am checking to see if the problem has been resolved.

If you have any update about this issue, please feel free to post back.

Looking forward to your reply.

Have a lucky day!

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Share via

How to write nested IF statement with equals for text?

1 answer

Your answer