-
Conditional formatting broken in table view?
I set up 3 CF rules across 3 columns. Above 60 is supposed to be green, between 30-59 is orange, and below 30 is red. I see no orange, AVG FPS column is not formatted and working at all, and some random columns aren't formatted. I also do not see "equal to or greater than" and "equal to or less than" as an option. What's…
-
New Table View - Format Rules buggy
I just started using the Table View for lists of contacts. I added a Format Rule that would highlight the entire row (except the Email Address field) if the Email Address cell is "blank". A second rule highlights just the Email Address cell itself in a slightly darker color if Email Address cell is "blank". This gives a…
-
Urgent help please! How to restore a sheet exactly as it was?
Hello! I need urgent help please! Is it possible, either locally on Smartsheet or with a third party platform, to restore a past version of a sheet to an identical format? I have tried the local Smartsheet backup, ProBackup, and am troubleshooting Fluentpro Backup. All have trouble with parent child cell relationships,…
-
How to restore conditional formatting, parent child relationships, and formulas?
Hello, I am trying to restore sheets to exactly what they were, with conditional formatting, formulas, and parent child relationships intact. Is there any way to do this? I am not a software developer, but I would very much appreciate any help the community can give! Thank you!
-
Custom Column View Templates
Is it possible to save custom views for columns? I would like to be able to show, hide, sort, and order columns via a template. I am able to filter based on specific conditions but I also need to be able to view the data a specific way.
-
Conditional formatting for dropdown with multiple options and OR condition
Hi experts, I have a problem with a conditional formatting rule not performing as expected. I have a dropdown field called "Transit country", and multiple country options can be added from a list (not blurring out the actual options as I'm sure we're all aware of current travel concerns). I've used Contains as it's…
-
Document Builder: Conditional Formatting & Symbols
It would be great if document builder was able to: either apply conditional formatting within the builder or carry through conditional formatting from the source fields/sheets able to pull through field properties such as symbols as the graphical representation rather than the backend text e.g. I want to include project…
-
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…
-
Conditional Formatting on Task/Outline Level Formula
I want to format rows based on the Outline Level. e.g. 1 = a darker color, 2=lighter, 3=lighter than 2, etc. I am using a formula to calculate Outline level: =VALUE(COUNT(ANCESTORS([Task Name]@row )) + 1) However conditional formatting is not working. What could allow this to work? Thanks so much!
-
Connecting Automation to conditional formatting
I am trying to figure out a way to attach automation to conditional formatting. For example, I have 4 columns, with the last one being a checkbox or another standardized trigger. I want to send out a notification that a row has been added, only when the checkbox in the last column is clicked. I set that up already because…