Subitemnames formula

Platform discussions Special workflows & use cases
,
1

Hi, I am wondering if someone could help me with a formula.

I am looking to count the number of subitems (formula would be on the parent) where the name (of the subitem) contains “Internal”.

eg
parent item
Internal 1
Internal 2

would have the formula return 2

thankyou for assistance.

2

Hi @Adurm

I don’t think there is a formula for this. If you subitems contain a number column you can achieve the same by:

  • in your subitem column click the column header and select “Show Summary in Parent Item”
  • in the new parent item click the column header and select “Settings”, now you can select “Count”

This will give you the count of all subitems that has a number. This can be different from the actual count which is displayed in the subitems column itself (in the parent item).

3

Hey @Adurm
Using a subitem column summary and General Caster you can count occurrences of “Internal” with a simple formula.
The downside is that subitems column support can be displayed for all columns except subitems’ name.

(LEN({item's Subitems Text})-LEN(SUBSTITUTE({item's Subitems Text}, "Apple", "")))/LEN("Apple")

Screen Shot 2021-06-28 at 14.49.44
Screen Shot 2021-06-28 at 14.49.441105×539 30.3 KB

Screen Shot 2021-06-28 at 14.49.59
Screen Shot 2021-06-28 at 14.49.591120×576 34 KB

3 Likes
4

Thankyou Rob. This looks like a good solution!

5

Appreciate the feedback. Unfortunate that monday has come up short again with basic column functionality.

Ive played around a bit with the general caster - but have ended up using an existing webhook i have already integrated (via firebase functions) to perform the formula and set the result.

6

Hi @Adurm :wave:

So glad you were able to figure out a workaround here!

At the moment, the subitems are still in beta, and with this in mind it does mean that not all platform features are currently compatible with the subitems.
Currently, does include the exact formula you’re looking to create I’m afraid.

As @basdebruin and @rob have suggested, General Caster would be a good workaround here, although it sounds like the Webhooks worked out for you better here!

I can definitely appreciate how this would be a useful addition to the platform for yourself, and I’m sure for other teams too, so I would highly recommend opening a thread in our Feature Request section.
Here other users who would also like this added to the platform will be able to upvote the feature!
You can find this here: Submit an Idea - monday Community Forum

Best,
Dani

1 Like