-
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…
-
Merged: Conditional Formatting Referencing Other Columns
This discussion has been merged.
-
Control Center - Global Update for Conditional Formatting
We would love to have the capability to push new conditional formatting using global update for provisioned project sheets. We have over 200 projects and whenever we get new ask for new conditional formatting (since things change all the time), it's a huge manual hours to go through and update each provisioned project with…
-
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…
-
Ability to Change Column Type When Conditional Formatting Exists
I would like to be able to change column types without having to delete conditional formatting rules. Currently I have 20 columns that I want to change from Text/Number to Dropdown List. They each have 5 Conditional Formatting rules applied to them. I can't change the column types without deleting the rules first. I can…
-
Merged: Applying Grid View Conditional Formatting in Bulk
This discussion has been merged.
-
why are theses column not being colored not by conditional format or by me ?
-
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?
-
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…
-
Conditional Formatting - Format based on comparison between cells not a Helper Cell
If I want to apply a conditional format to Column B on the proviso that Column B is greater than Column A, I must use a Helper Cell to determine if this is True or not. Like Microsoft Excel does; by including the ability to specify a formula to ascertain whether a Format should be applied would be a lot cleaner than having…