-
How to Allow People viewing a shared link to change views
Hello, I want people outside of my organization who are viewing a live link of my sheet to be able to view the sheet in calendar or board view. Is this possible? If not, any recommendations on how a sheet can be manipulated to offer a beeter viewing experience than just the default grid view? For people viewing outside the…
-
How do I apply conditional formatting to a single cell?
Hello, How do I apply conditional formatting to a specific cell? For the example below, when I click on the "B/C" check box, I only want to highlight the B/C within that row and not that column. Wasn't sure of the best way to do this.
-
Need help with conditional formatting
HI, I want to make a conditional formatting rule for IF "ETA" is greater then "TARGET RECEIVE BY DATE", then highlight yellow. The current columns are formatted for TEXT/NUMBER. Not sure if they need to be in DATE format within column properties.
-
Send automated alert when a cell changes from a specific value to a different specific value.
Hi team, I was attempting to build out a process for an automated alert to be sent based on a value in a cell (drop-down list(constant)) changing to a different value (also from the dropdown list) of that same cell. I would like want the alert sent if it was being changed from that specific value to another specific value.…
-
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…
-
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.