Hi

I wondered if someone could possibly help. This has me stumped. I’ve created a spreadsheet where Power Automate populates a table with answers from a quiz. It’s working well. The issue is as follows. On questions with multiple answers, the cell is populated like this…

[“water”,”stone”,”plants”]

It has to be this way as far as I understand. I need to then use the IF formula in the picture to populate another cell, ‘if the answer matches this exact permeatation, then show 1”

Whereas this formula works for other answers and values, it really doesn’t like the square brackets.

How do I tackle this?

Thank you in advance 

​Hi I wondered if someone could possibly help. This has me stumped. I’ve created a spreadsheet where Power Automate populates a table with answers from a quiz. It’s working well. The issue is as follows. On questions with multiple answers, the cell is populated like this… [“water”,”stone”,”plants”]It has to be this way as far as I understand. I need to then use the IF formula in the picture to populate another cell, ‘if the answer matches this exact permeatation, then show 1”Whereas this formula works for other answers and values, it really doesn’t like the square brackets.How do I tackle this? Thank you in advance       Read More

​