-
Setting up Alerts
We are running a number of different projects on a sheet that have a: 1) - Delivery Deadline (which is specified by the client), 2) - Delivery Date (which is set by dependencies on our Production Schedule) When Production is running late, the Delivery Date can end up later than the deadline. How can we set up an alert to…
-
Is there a way to auto sort data on a sheet (cannot use report) to show the Largest to Smallest?
Hello, I am creating dashboards using metrics and am trying to figure out a way to only show the top 15 of specific data. Sheet details: I have one column that contains 298 different locations and the next column is the # of issues at that location for last week. I have the formulas figured out to pull in the metrics…
-
How can I include an attachment shared to the sheet in requests for approval?
I am using a sheet to manage a client contract approval process. I am imagining attaching the draft contract to the sheet itself or to a single row towards the top of the sheet. I have several approvers listed below in separate rows and need to send out requests for approval with the draft contract attached. Is there any…
-
simple total column
I have set up 2 sheets similar to the inspection submissions and metrics template i found in the solutions center. I use it to collect postage cost per month. I have the submissions feeding into the metrics page with a SUMIFS formula. All of that is working fine. However when I want to total the row for a monthly total…
-
Hide #INVALID DATA
Hello, I am attempting to calculate the difference between two dates. When one of the dates is missing, the cell where the difference would be shown instead contains "#INVALID DATA". Can anyone please help? I've attached a screenshot. The "Actual Duration" column is the difference between the "Start Date" and "End Date". I…
-
Setting flag when task falls within a date range
At my company we have certain dates when we do not make changes to our website (holidays usually). I'd like to be able to highlight or somehow flag a task if it falls within one of the freeze date ranges. Is there a way to do this?
-
User name display
Hi I am adding new users to smartsheet but would prefer that their first and last names show and not just their email addresses. This happens even if I add them to my contacts? Is there something that I am not doing correctly? which is not allowing the display of their names the way we want it. Any assistance is…
-
Update Request Form
Hi, I am wondering if there is a reason why my update request will not let the user update % Complete. Does anyone have any insight to why it will only allow certain things to be updated? The way the Request is set up is: "On 03/04/19 at 11am In any row where % Complete is less than 100% and Start Date is in the past Send…
-
Smartsheet Excellence - worth it?
Looking into either Smartsheet's excellence training or another bigger picture project management training. Does Smartsheet's excellence courses provide value beyond just the Smartsheet tool? Basically, I'd prefer something I can grow my project management training that doesn't tie me to a specific tool (even though we'll…
-
Copy Rows Between Sheets Based on Checkbox
I am trying to create a calendar or events based off a master list of events on another sheet. The source sheet is a master list of all possible events. That sheet contains a column of check boxes. When a checkbox is checked I would like it to automatically copy that row from the source sheet to the destination sheet. The…
