Verification that all boxes on a multi-select list are checked
Hello, I have a multi-select list that has 5 items on it. All 5 items need to be checked off for quality purposes. I created a separate formula field to check this condition, but I can't figure ou...
- @Joseph Rysavy There may be an easier way to approach this.
There is a new function called Size() that largely is used with Query Formulas but also works with multi-select fields.
If(Size([The SOW was reviewed and SOW has the following items:])=5,"Good","SOW is not complete")
I share a bit about this in the "Oh So Fantastic Formula Query Functions" video here: https://youtu.be/OsfngR4DGWg?t=324
If you want to stick with you original approach, use this variation with the "Contains" function:
If(Contains([The SOW was reviewed and SOW has the following items:],"Anticipated LOE by Contract Labor Cat (Qty & Hrs) by JID") and ... <add remaining conditions>
Let me know if this was helpful 👍
-Sharon
------------------------------
Quick Base Junkie
------------------------------
