How do I configure the row as complete when all the columnโs filled up?
How many columns do you have?
What column types they are? Or can they be what ever?
There are text type, number, image, date and price.
What does โconfigure the row as completeโ mean?
If all the columns are filled with the required data, then its complete. If even 1 columns missed then not complete. Iโm thinking of giving a sign such as color to mark it as complete.
Thereโs no trivial way to do it. The best you can do is a big OR() expression:
OR(ISBLANK([Col1], ISBLANK([Col2], โฆ)
The expression is TRUE is any of the columns are blank (empty).
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |