Hi Jason,
Interesting challenge. I’m operating on the logic that each successive item can only be filled if the one before is filled first, (ie. item3 has to be filled before item4 is filled.)
In that case, I think this is what you need. (Totally untested).
IF({Item1},IF({Item2},IF({Item3},IF({Item4},IF({Item5},IF({Item6},IF({Item7},IF({Item8},IF({Item9},IF({Item10},IF({Item11},IF({Item12},IF({Item13},"ALL ITEMS FILLED",{Item12}),{Item11}),{Item10}),{Item9}),{Item8}),{Item7}),{Item6}),{Item5}),{Item4}),{Item3}),{Item2}),{Item1}),"NO ITEMS")
It’s a messy one I’m not sure how to make pretty. But here is what’s being combined:
IF({Item1},notblank,"NO ITEMS")
IF({Item2},notblank,{Item1})
IF({Item3},notblank,{Item2})
IF({Item4},notblank,{Item3})
IF({Item5},notblank,{Item4})
IF({Item6},notblank,{Item5})
IF({Item7},notblank,{Item6})
IF({Item8},notblank,{Item7})
IF({Item9},notblank,{Item8})
IF({Item10},notblank,{Item9})
IF({Item11},notblank,{Item10})
IF({Item12},notblank,{Item11})
IF({Item13},"ALL ITEMS FILLED",{Item12})
In each line, looking if an item is blank, and if it is then it resolves the text from the previous item. If it’s ‘notblank’ then continues to the next IF statement. If the first item is empty, it should say “NO ITEMS” and if all the items are filled out, it should say “ALL ITEMS FILLED”
Again, totally untested, but hopefully helpful :slightly_smiling_face:
