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…
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 approve…
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 m…
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…
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 ran…
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…
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 …
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? Basicall…
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. Wh…
I am trying to create an auto flag on a project that says if % complete is <= 80% and the end date is <= 7 days from today then flag. Here is what I have so far =if([% complete]<=0.8,0.5,0)+if([end da…
