-
Format Parent Rows Only with 'Helper' Columns Not Helping...
Hello, New to Smartsheet and trying to learn! None of the posts on the community have worked but I believe this is a basic question. Using indentation, we're creating parent/child rows for individual projects. I simply want the parent row to be able to highlight a color for that whole row once created to visually separate…
-
Sending form user to another link using conditional logic
Is there a way to send a user to another link once they've submitted a form, using conditional logic based on their specific form responses?
-
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…
-
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.
-
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?
