-
Text Decoration in Higher-Priority Conditional Formatting Rules
Current state example: Two conditional formatting rules. The lower-priority one sets font weight to bold. The higher-priority one sets font weight to normal (not bold). The result, in a row that triggers both rules, is that the font weight remains bold. It is not overridden by the higher-priority rule. Desired state: The…
-
Merged: More Color Options for Background and Text (Grid and Conditional Formatting)
This discussion has been merged.
-
Merged: More color options in conditional formatting
This discussion has been merged.
-
Convert to Column Formula grayed out
I'm trying to use Conditional Formatting on a Status column to change the color of the bubble based on the value of the Stage. I'm using the following and the option for Convert to Column Formula is grayed out: IF([Stage]@row = 'Not Started', "Gray", IF(AND([Stage]@row = 'Testing'), "Yellow", IF(AND([Stage]@row ='Done'),…
-
Integrate with Outlook with Dates and Times and Assignee Information
The outlook integration as it exists is nice if you only have one or two projects. As a single user I manage hundreds of projects at a time I would like to be able to sync my calendar to outlook in a more integrated format. For example, when i set a task or appointment date in Smartsheet I would like to be able to…
-
Linking Sheets in Workspace, Cell Pull through based on conditions
I am creating a series of sheets in a workspace. The idea is that there is one master log that feeds other logs as it is updated. The child logs would be fed once a condition on the master log is met, the kicker is that I don't want a line for line transfer leaving me with blank lines if a line on the master log has not…
-
I cannot convert my if statement to a column formula
I have an if statement referencing another column named "Country" - I want to define this if statement into a Column Formula but it says "the column formula syntax isn't quite right". This is my IF statement. =IF(Country1 = "US", "01-440-0187 (US)", IF(Country1 = "Canada", "01-440-0188 (CA)", IF(Country1 = "Mexico",…
-
API Conditional Formatting
Hi - It sure would be nice to have the ability to update conditional formatting via the API. I see a thread from 2016 - is this something that the dev team could look at? Many Thanks, Sean
-
Preserve original formatting in automated alerts
Dear Smartsheet team, I found that the automatically generated table by Smartsheet and incorporated to email (generated as a part of Alert someone automation workflow) for some reason lost the formatting of cell, f.i. if on the original Smartsheet webpage the cell is colored in green and text is bold in email I see regular…
-
Lost of cell formatting (color, font type) in Alerts someone email
Dear users, I found that the automatically generated table by Smartsheet and incorporated to email (generated as a part of Alert someone automation workflow) for some reason lost the formatting of cell, f.i. if on the original Smartsheet webpage the cell is colored in green and text is bold in email I see regular font and…