-
Sheet Compare to highlight differences
The ability to compare sheets that have a similar layout and list differences between them. I know using Control Center and Global Updates to rollout projects and project changes will solve this issue but I have current/legacy projects that were manually created. It would be awesome if I could compare sheets in an attempt…
-
Multiple Logic Requirements in Forms
Is there a way within a Smartsheet Form, two have a field only show if two fields are equal to a certain value? i.e if field one equals x and field two equals y show field three.
-
Impact/target Multiple rows within the same group
Is there a way to impact multiple rows using a workflow? If I select "No", on "remote access" Column, I want the system to populate "Yes" on "was report delivered" column and today's date on when was the report delivered. "This is already happening successfully on my end" However, I want to target rows 3,4,5,6 with the…
-
Conditional Formatting
Hi Everyone, Is there a way to remove one of the conditions from the rule? For instance, I have set up a rule that has 10 conditions, I just want to remove one of the conditions from the rule without having to delete the whole rule.
-
Conditional Format For "Task Bar" independent of "Entire Row"
My use case I have rules for various rows based on the Issue Type and I want a rule for the Task bar based on the status of the issue. For example, I want an Epic to show up with a Grey background, but I do not want the grey background to extend into the Gantt Chart but I want the Gant chart to show up as Green if the task…
-
Multiple IF / AND / OR Statements Help, Please.
This is such a great community and a wealth of knowledge for a new Smartsheet user like me. I have done several formulas, but this one has me scratching my head. I have a [Target Date] column, [% Complete] column, and status column that I would like to automate with Red, Yellow, Green, and Gray status balls. The [%…
-
Automated Reminder Status Linking
I am wondering if it is possible to link automated reminders to my status colors on my Gantt chart. For example, if an item is completed, it turns green; if it is due in 7 days, it turns yellow; and if it is due on the day or is overdue, it turns red. And if it is overdue, then it wont sent out the reminder.
-
Conditional Formatting Not able to select in list even though it's in a dropdown column
I have a column that is a dropdown column that I want to be able to select from a list in the conditional formatting tool. However the list view does not have all my choices even after I have saved my sheet and refreshed it. I know I could use the define custom criteria and do each one individually but that would take a…
-
Source Sheet Conditional Formatting on Dashboard Web Content Widget
Over the last few weeks, I have received notifications from users that the Conditional Formatting on a Source Sheet is not accurately reflecting on the Dashboard that our end-users are accessing. The Conditional Formatting on the Source sheet is reflecting as expected. However, the dynamic view is incorporated on our…
-
Why is the branching logic in my form not working?
I have logic set up in a dropdown field that says if this field contains X, show the Y field. My issue is that the Y field is showing regardless if X is selected from the dropdown or not. Anyone know why this is happening?