Conditional Formatting of subitems

[Matt-W-P (Matt Watson-Power)]

I would like to have conditional formatting available for subitems.
Usecase - I have a number of sub items that require a workshop / playback session. I would like to prefix the description of these with [TB] (stands for 'Touch Base) and set it so that it’s highlighted. That way - at a glance - we can see what things in the future require a meeting space / resource (including external). coordination etc. If this feature already exists, I’d like it so that I can intuitively find it.

[sudewa (Sudewa Nawarathna)]

We have the same requirement. I noted this is not in Monday road map.

[rnoonan (Bobby)]

We too need this ability.

[MHaigh (Matthew Haigh)]

At the moment, formatting on the subitem, isnt supported… as a sort of workaround… the nearest I can ben able to do to make subitems more easily identifiable, is to add a formula column in the subitems, then use a formula with Emojis… example below which helps like the following…
IF({statusColumn}=“Done”,",IF({PriorityColumn}=“High”,“”,IF({DateColumn}>Today()+7,“Overdue”,IF(LEN({PersonColumn})=0,“Fill in Person Column”))))
… I use formulas like this to guide people through filling in fields or highlighting errors in data…
Hope that helps, and hopefully Monday will extend the colour formatting to subitems soon.

[Firenta_Andy (Andrew Causton)]

Just to support these comments, we would love to see this too.

We are currently using the tables with the main items and individual project and the sub-items all the steps within the projects, but we would like deadlines and submissions to be highlighted to draw focus in. The only option is therefore to make all steps main items but the boards end up ridiculously big.

[robertoa (Roberto Alvo)]

Supporting this request, would be really useful to have that.

[Frederic (Schmutz)]

Hi, we use the subitems to be showed in the Workload view. Would be great to have them in different color.

[EYDER (TINAR)]

We also need this to guide our employees through important columns.

[kolaai (alfred)]

Hello everyone

An alternative option is to use the Icons app to conditionally attach icons or text to your item names. There are 1000s of icons to choose from and you can even use your own icon or text.

If you need any help with the app, you can always reach out to support@kolaai.com

[galaxia (Juliette)]

We too need this, urgently!!!

[Rebekka (Rebekkas)]

Yes, I support this request too! Would be super beneficial for us as well

[MarkP (Mark)]

One more vote and comment in favor of this feature. There are many practical applications for this.

[jmtornetta (Jon Tornetta)]

Same here. Would love this.

[jsararas (Jeff)]

@MHaigh Absolutely owe you a pint for this one Matthew! 5 red squares vs 5 green squares is pretty much as good as a status flag

[MHaigh (Matthew Haigh)]

Glad it worked !

[ntburkhart (Nathan)]

Hey, I’m looking to do something exactly like this with the date overdue piece but I’m brand new to formulas. Would you be willing to spell out a formula that would indicate “Upcoming” if it were within 90days of a date and “overdue” if it is after a date? Thanks!

[MHaigh (Matthew Haigh)]

Something like this…
IF({ThisDateColumn}>{dateDuecolumn},“Overdue”, IF({dateDuecolumn}-{ThisDateColumn}<91,“Upcoming”))

[ntburkhart (Nathan)]

Thanks for the response Matthew! I’m still getting an error and suspect I’m getting tripped up on the {ThisDateColumn}. I’d like to reference the due dates to “today” so if today is within 90 days of the due date it flags as upcoming or if today is past the due date it flags as overdue. Would I need a column with the Today function and use that as the {ThisDateColumn} or is there a way to simplify and reference today in the formula?

[MHaigh (Matthew Haigh)]

Hi
No, you can replace {dateDueColumn} with TODAY()

TODAY() will return a date with todays date and you can use this directly in the formula.