-
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…
-
Conditional Formatting based on Status and End Date
Hello, I know this may be have been answered before but I would like some help with the following. I have a sheet with % complete Status (Not Started, In Progress, Blocked, and Complete) Start Date and End Date I would like to create some sort of FLAG or conditional formatting with the following logic. If due date is in 3…
-
Conditional Formatting for Dashboard Metric Widgets
When using dashboard metric widgets, it would be helpful to be able to have conditional formatting features to compare performance to a KPI or otherwise enhance the metric display. Even if the data source document already has the conditional formatting existing, it will not transfer along with the data to the dashboard…
-
Send notification 2 weeks after start date
I'm creating a training list template and would like to notify the manager 2 weeks after the start date of any tasks that are marked "not started" or "in progress". the issue is that I can only select a date from a calendar in my conditions but instead I'd like to make it "two weeks from start date".
-
Lock Column Settings
Hello all!!! Quick question I feel like I know the answer to. But is it possible to change a lock column setting so the column locks after a condition is met? For my example a column to only lock after a status is changed to a certain value.
-
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…
