conditional formula for Microsoft list

Question

conditional formula for Microsoft list

Wu, Vivian:(PECO) 40

why didn't this formula work in Microsoft list?

=if(or([$JobType]=='Electric', [$JobType]=='Gas'), 'true', 'false')

Yanli Jiang - MSFT 31,666 Reputation points Microsoft External Staff

2024-10-31T01:39:51.8733333+00:00

Hi, we are currently doing some research on this issue, will let you know as soon as possible.

Answer accepted by question author

0 additional answers

Your answer

Yanli Jiang - MSFT 31,666 Reputation points Microsoft External Staff

2024-10-31T01:39:51.8733333+00:00

Hi, we are currently doing some research on this issue, will let you know as soon as possible.

Answer 1

Yanli Jiang - MSFT 31,666 Microsoft External Staff

Hi @Wu, Vivian:(PECO) ,

Welcome to Q&A forum!

Are you using calculated column to make it?

If so, please try the following formula, which works in my environment.

=IF(OR(JobType="Electric",JobType="Gas"),"True","False")

User's image

And the result:

User's image

Hope this can help! :-)

If the answer is helpful, please click "Accept as 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.

Yanli Jiang - MSFT 31,666 Reputation points Microsoft External Staff

2024-11-04T08:37:51.21+00:00

Hi @Wu, Vivian:(PECO) ,

Did you get chance to look into my answer? Let us know if you have further questions.

If the answer is helpful, please click "Accept as Answer" and kindly upvote it.

Share via

conditional formula for Microsoft list

0 additional answers

Your answer