Check all collums in a row

Ask the Community
1

hi

so my use case here is to have a form with a long list of questions about inspecting a complex piece of equipment.

i want an end calculated field that checks all the questions for the word ‘FAIL’ and gives a final ‘PASS’ /‘FAIL’ result that i can then use for later automations ext.

so far the only way i have found to do this is by listing each column explicitly to check against in the formula. this would work but its

A. its just really dull to write out for my 25+columns

B. not a great for maintinance, if i later change equipment and the questions are added or removed as ill also need to remember to go and change this formula.

anyone got a good workaround for this or do i just need to bite the bullet and write it all out?

thanks

2

I strongly recommend that you do not make the columns represent the questions, it will become a maintenance nightmare.

Rather do

Company 1, Question 1, Fail
Company 1, Question 2, Pass
Company 2, Question 1, Pass
Company 2, Question 2, Pass.

Then do your formula on the 3rd column. Adding or removing questions in the future will by MUCH easier.

3

:waving_hand: @Michael_Paget

Docs AI works a charm for writing those tedious formulas! but be sure to check/test it and make sure its right.

Otherwise, my other suggestion would be if youre worried about scalability/maintenance issues for the future (deservedly so!) to use an AI column.

Hope this helps!

Cheers!
Mel