How do I configure the row as complete when a...

How do I configure the row as complete when all the column’s filled up?

0 7 382
7 REPLIES 7

How many columns do you have?

  1. 15 column 2) 25 column not counting Id column

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).

Top Labels in this Space