Conditional Formatting based on system columns (Attachments and Comments)

Stephan Lafrance

I can't find any discussions on this. 

 

I'm looking for conditional fomatting based on two of the three System columns: Attachments and Comments. These are not available today when trying to add conditional formating to a row.

 

For attachments, I would like the criteria based on:

  - Changed: If the list of files has changed at all

  - New: Only if a new file has been added

  - Changed Existing: If a new version of a specific file has been uploaded

 

For Comments:

  - Changed: If any new comments have been added

  - Replied: If anybody has replied to a specific comment

 

Please consider this a request if this functionality is not available today.

 

Thanks,

Shaine Greenwood

Hi Stephane,

 

We currently don't have a way to create conditional formatting rules for the Attachments and Comments columns on the left of the sheet but I've got your vote down for this on our enhancement request list for further consideration. 

Joseph Aulet

My team would greatly benefit from conditional formatting based on the attachment. 

 

+1 for me please.

J. Craig Williams

Those would be useful.

 

+1

Craig

Shaine Greenwood

Joseph & Craig—I've got your votes down as well.

davidl

I would like a feature like that.  It would be nice if you could make the comment or attachement (or other system column) cell for a row, lets say red, if there is a comment.  Sometimes i find a need to draw attention to a row with a comment.   Without that comments can get lost.  I'd be happy with just being able to fill the cell manually in the meantime.

rwpatty

+1 from me as well. Thank you.

aricker

This would be very valuable for me.  Was looking into figuring this out and couldn't see a way.  Glad others are wanting the same functionality.

Patrick Galvin

+1 from me as well please

Euroclass

Absolutely would love this feature to be enabled. Vote from me. 

Alex Popa

Conditional formatting based on attachment would be a great addition. This has my vote.

Sergiy Gavrylyuk

+1 formatting on attachments

sdkotes12901

This feature would be very useful for our organization as well. 

Count me in!

Julie

This is becoming a dealbreaker for me.  I have personally missed several comments because the speech bubble is not clear enough.  This is mainly when I am searching through historic records and producing a report collating many sheets - I need to be able to clearly see which rows have comments.

The ability to use conditional formatting to highlight The bubble when comments have been added to a line is vital!

Please tell me it is being worked on...

J. Craig Williams

For Comments on critical sheets, I have added a Zap (using www.zapier.com) that flags new comments or new replies to existing comments. Also can put those into columns for "most recent comments", only the last one for now.

It can not be used to capture edits to existing comments.

Craig

Keith Tham

+1 Vote again.  Conditional formulas on Attachment column for alert, update and approval requests if possible as well.

 

Thank-you