-
Conditional Formating on Workflow Emails
As of right now, there is no way for conditional formatting to show on emails that are generated through workflow. I suggest implementing a method to allow this, for example, I have conditional formatting that highlights fields when a specific criterion is met, but when I send that email out via workflow that…
-
How to use the condition in request automation?
I am very new to Smartsheet and needing a bit of help. I am trying to set up a request update automation for individual fields as needed. For example I have approximately 32 fields that are autogenerated from a form. I am then trying to send an automation update request for fields that have a text associated in them,…
-
Logic Condition Formula (color symbol) is not working
I have been using a condition/logic formula on my sheets for 4 months. Today when I logged in, the formulas are not working correctly. Has anyone else experienced this issue? This has affected multiple sheets with same/similar formula. =IF([Next Action]@row = "Actively Monitoring", "Yellow", IF([Next Action]@row =…
-
Conditional Formatting for a Modified By Column
I am trying to create an automation or formula to populate a cell. Here's the gist of what I am trying to accomplish: Only when a completed box in a column is checked → I want to populate another cell in that row with the Current User who checked the box. I would like this to populate automatically through the use of a…
-
Coloring
Is there any way to use Color Hex Codes to further customize the columns, rows, and/or text of our workspaces? If not, please add this in future updates.
-
Comparing Columns on Two Different Sheets
I have two sheets that I need to compare data and highlight any matching data. If Sheet "A" query column matches any of the data in Sheet "B" query column, then the matching data in Sheet "B" query column needs to highlight. I've not had any luck finding a formula that works. Any thoughts?
-
Conditional formatting for Reports
The ability to apply conditional formatting rules from within a report would be huge. Having to modify the Source sheet for a specific report doesn't seem to be very efficient.
-
Manage multiple values in a cell from a dropdown list
Good morning, I am facing an issue on my smartsheet, i have a column (dropdown list type) that allowed multiple values per cells and i am trying to manage these different values in order to concatenate them the way i want in another cell. Does anybody knows the way to pick a single value from all of them or even the way…
-
Collapse Lanes in Card View
There currently isn't a way to automatically collapse lanes based on criteria (such as "no cards") or to use one click to collapse all. Currently I have to click each column to collapse individually, to show/hide what I want.
-
Merged: Custom Colors on Cell Formatting
This discussion has been merged.
