Sign in to join the conversation:
Since the new format I am lost in adding other aspects of the filter function. What happened to adding colors and highlights when creating a new filter? Please help!
Hello Elizabeth,
It sounds as if perhaps you are looking for the Conditional Formatting feature, rather than filters. With conditional formatting you can add color to rows or cells based on criteria you specify (for example, you could create a rule so that if a task is assigned to Gwyneth, the the row will be highlighted in yellow).
To start creating a conditional formatting rule, click Conditional Formatting in the toolbar at the top of Smartsheet to display the Conditional Formatting window.
You'll find more information about how to work with conditional formatting in the Smartsheet Help Center article "Apply Formatting Automatically with Conditional Formatting Rules" (https://help.smartsheet.com/articles/516359-conditional-formatting).
Hope this helps!
-Gwyneth
Can excel sheet be used as a reference in Smartsheet?
I have a State account
Hi Can you utilize forms to make data entry easier into a row that already exists?. For instance, if I have pre-populated a sheet with 100 rows/items can I use a form to update certain columns in these rows…to make columns with multiple lines of text easier to enter? Many thanks Matt
