Archived 2016 Posts
Archived 2016 Posts
Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Conditional Formatting, enhancement requests
BMar
✭✭
Some features I would like to see in the future:
1. Allow using a formula for conditional tests. Using only the drop-downs is rather limiting.
e.g. If COUNT(CHILDREN())>0 then apply...
2. Allow selecting multiple columns to apply formatting. It's super annoying to clone a rule several times to highlight multiple columns.
3. Allow grouping of rules to organize long lists and clearly show hierarchy. For example, a group of rules that intensifies the fill colors as a due date approaches:
Rule
Rule
Group (expand/collapse)
-----Rule: If [Due] is Today...
-----Rule: If [Due] is Today +1...
-----Rule: If [Due] is Today +3...
Rule
1. Allow using a formula for conditional tests. Using only the drop-downs is rather limiting.
e.g. If COUNT(CHILDREN())>0 then apply...
2. Allow selecting multiple columns to apply formatting. It's super annoying to clone a rule several times to highlight multiple columns.
3. Allow grouping of rules to organize long lists and clearly show hierarchy. For example, a group of rules that intensifies the fill colors as a due date approaches:
Rule
Rule
Group (expand/collapse)
-----Rule: If [Due] is Today...
-----Rule: If [Due] is Today +1...
-----Rule: If [Due] is Today +3...
Rule
Comments
-
+1 from me for an update to Conditional Formatting
Craig
-
+1 on all 3.
-
Hi All—thanks for the feedback. I'll send your requests and examples to our Product team for further review.
-
+1 from me too!
This discussion has been closed.