-
AVG Not Calculating
I am trying to avg each row (Center Average) based on % of compliance in each category. "1 is compliant and "0" is non-compliant. The % Compliance columns are calculated using =(COUNTIF([FD 1]2:[FD 12]2, "1") / [# Front Desk Questions]#). As you can see, the average is not calculated correctly. For example, the row with…
-
Counting the number of sheets in a folder
I'm trying to add a dashboard widget that illustrates via bar chart the number of projects in two different portfolios. I can create a report that lists all the projects in each portfolio folder, but as we know we can't summarize the report so it can feed a widget. Probably a simple solution, but any help would be…
-
Viewing Capabilities
I have a Smartsheet that has sensitive information. This is a two part question... If the person submitting the form is listed as a Commenter, is there a way for them to only see their request and nobody else's in the Smartsheet. We want to limit them access to only see their request, and nobody else's. If we do not give…
-
Is this scenario possible?
Im trying to find out if the possible scenario is possible in smartsheet: Im trying to create a time based resource model with input from a questionnaire. I have the resource requirements in 1 data sheet (ie what resource does it take to complete a list of activities for an item) - Sheet 1 below i have a 2nd sheet that…
-
Using Count & Distinc formulas to
Hello everyone!, I'm having troubles trying to get the count from a list and showing in other sheet (For this image, I put it in the same sheet but I'll on other "data sheet"). In the other sheet; I would like to have the count of unique date related with de responsible Column "Resp". So if someone put any kind of task…
-
Business days since line created
I need to calculate workdays since date created if a line is NOT "completed". So if a line is still not completed, I want to know the aging date since line was created. I have a formula to calculate ho many days have passed since a line was created if not completed, but I am lost trying to only pull workdays from the…
-
Copy a range of cells under a parent or ID number to another sheet
We have a wide range of purchase orders which can be created for any job from 1-50. There are about 6 different PO groups I would like to pull data from and assign them to their individual projects in their corresponding rows. Is there a function where I can call the parent and it will copy the parent and children…
-
Meeting SLA Formula
Hi there! I'm working on an SLA formula. The "Approve/Decline Date" must be within 4 business days of the "Request Received" date. The formula is in a helper checkbox column. I will then use this to calculate the % of events that meet the SLA for each team member. I am stuck on how to note 'business days' in the checkbox…
-
Compare dates in a column and return a value if match in another column
There are two columns that I need to count and match: Date of Purchase Lead Tech Here is what I need the formula to do: If there is a name that appears more than once in the Lead Tech column, then: Count the number of times they appear in the last 7 days and last 30 days using the Date of Purchase column. Return a value of…
-
KPI/SLA notification/alerts
Hi, I'm trying to establish various kpi interval tracking and notification if out of sla. I'm having a VERY hard time coming up with how this should work. Example: Received date is 12/1, sla time frame is 12/1 + 2 days = 12/3, however, if received doesn't change to next step, order submitted, i need a notification sent.…
