Automatic status change when all text columns are filed?

Platform discussions
, ,
1

Hello, pretty new here and try to figure out things for my small sales team.
I didnt know how to set up a board where a status column, or a progress bar which will show 100% full, or Completed, only if all the text columns of that item are filed with text. ( we try to make sure that we didnt send out any offers whitout all the informations which are needed, this is why is so important that all our 43 columns to be filed out with informations. Thank you for your help guys!

2

@ArvaConrad

If you’re good with a visual indicator (vs. an actual status column), this formula will do that:

CHOOSE(INT(LEN(SUBSTITUTE(
(Len({Text 1}) > 0) & (Len({Text 2}) > 0) & (Len({Text 3}) > 0) & (Len({Text 4}) > 0) & (Len({Text 5}) > 0) & (Len({Text 6}) > 0), "false", ""))
 / 4 / 6 * 5) + 1,
 "⬛⬛⬛⬛⬛", "🟩⬛⬛⬛⬛", "🟩🟩⬛⬛⬛", "🟩🟩🟩⬛⬛", "🟩🟩🟩🟩⬛", "🟩🟩🟩🟩🟩")

You can add as many text column references as you want. Just change the section “… / 4 / 6 * 5…” replacing the “6” with the number of columns you are testing.

By the way, this formula could be modified to do other test as well. Like

  • ({Number} > 0)
  • ({Number 1} <= {Number 2})
  • ({Status} = “Done”)
  • ((DAYS({Start Date},TODAY()) < 20)

If you have to have an actual status column, your best bet in the short term is probably creating an Integromat scenario.

Jim - Subscribe to The Monday Man
Watch Our Latest Video: Quick Tip - The Trick to Editing Custom Automations