-
Changing Colors - Card View
I can't figure out why the colors aren't showing up in card view with conditional formatting. It's working fine on grid view and table view. I have tried coloring everything or just the status, and "high priority" items should have red text. When I go to board view, it tells me to go to card view to change the conditional…
-
Color Scale
I read an old thread from 2018 about this, but is there a plan to provide users the ability to do conditional formatting using a RYG color scale based on high/low values?
-
Conditional Formatting Based on Min & Max Columns
I have a sheet that shows the stock of all promotional items across several locations and I'm trying to set up conditional formatting to highlight the cell if it's less than or equal to the min amount. I can do this manually for every row but wondering if there's a way to do this similar to how excel & Google sheets have…
-
How do add columns in smartsheets dynamically based on a condition ?
I have the date of implementation of the project and I need to dynamically add the columns based on the date. Like for example if I had a 1-2-2024 as my date. It must give ,me 12 months for that date like march 2024 to jan 2025 each column contains 1 month a total of 12 columns and adding to it I have so many projects some…
-
SIMPLE Conditional Formatting is not Working
I have never had issues with conditional formatting, even when formulas were required. This one is simple, it is NO formulas, just based on the user's selection from a dropdown that appears in this sheet. The first screenshot shows the column example. Most are declined here, and those should be highlighted ORANGE based on…
-
why are theses column not being colored not by conditional format or by me ?
-
Merged: Applying Grid View Conditional Formatting in Bulk
This discussion has been merged.
-
Highlight new row
I have an automation that copies over a row each time it meets a criteria. is there a way to highlight the newly added row in the destination sheet by automation/conditional formatting?
-
Automatically Delete Attachments when a condition is met
To save on storage space, I would like to automatically delete attachments to a row when a condition is met, as I would no longer need to reference those. Thanks!
-
Numbers in Form
My Regional Number Settings are: 2 500,00. In the Form, I have a field that only allows numbers. Form input rows to the worksheet. Unfortunately, the Form doesn't allow the "," entry. In the Form, the number must be entered as 2500.00. However, such a value transfered to the column (with setting as Text/number) in…