-
Smartsheet Dashboard to WorkApp
Hello. Like all of you, we have our customers that love to tell us their desired UX. I start off with honesty. No tool is perfect, there are limitations and we will address the must haves and nice to haves respectively. The biggest concern is addressing what value can Smartsheet bring that makes their work lives easier to…
-
Policies and Procedures
Hello, I serve as the compliance officer for a nonprofit mental health outpatient clinic. We are new to Smartsheet. Our goal is to have a single source of truth for policies and procedures. I used the Risk Assessment template and found it easy to work with. Now working with the Policy Governance Inventory template. Diana
-
Need help excluding weekends in estimated completion date formula
Hello! I am currently working on a Smartsheet that estimates how long a project should take depending on a multitude of variables. So far all my formulas are working great, but I am using the following formula to determine an estimated project completion date: This formula is unfortunately accounting for weekends as well,…
-
traffic data in 6-hr intervals over a 12-week period
Hi All, I want to show data in 6-hour intervals over 12 weeks (Feb 2024 till April 2024). How do I create a dashboard for it? Columns include: Only if I can know the total number of tickets received for the past 12 weeks in 6 hour timely interval for the past 12 weeks Any help would be highly appreciated.
-
Index and collect most recent text and where not blank based on Max Modified date?
I'm using the following formula to collect the most recent comment from children cells. We are having an issue when a user adds a comment and then deletes it and/or types a new comment within the same cell within the same minute. When this happens, the parent retains the blank cell "comment" or doesn't recognize the new…
-
Contact list in forms
My sheet has an "assigned to" column, but I am wanting to reference my contact list for the available options. I know when I am directly editing the sheet, I can begin typing the contact name/email address and will see a list of available options - but the same feature is not available on through a form. Is there a…
-
Formula to Flag a Task if it's Predecessor is Delayed
Hi all, I am trying to develop a formula that flags/checks a box for tasks whose predecessors are delayed. Please see below for additional requirements and my work/understanding so far: Sheet Details: I have Predecessor and Successor columns with those names. My task column is named Milestone / Task My finish date column…
-
MS Teams asks me to log in on a daily basis
Each time we are accessing Smartsheet via MS Team we have to log in again. It will than remember the credentials, but the next day it starts all over again. It's giving the following message: Please log in to your smartsheet account to access this published item. Is this a known issue and is there a solution for it? It's…
-
Data Collection
Hello I am trying to create a sheet to manage my labels inventory and I want to find the best way to enter existing inventory into my new created sheet. I have created a form with the two required fields, i will be using one handheld scanner to read the data from bar code labels, I would like to know if there is a way that…
-
Removing a field from the Summary & project sheets
I have a field coming from one of my project sheets feeding to my Summary sheet that's been replaced / is no longer needed. I'd like to remove it but wanted to know if there was anything I should keep in mind. If I just delete the field from the summary sections of all my projects & delete the column in the Summary sheet,…