-
TRIMMEAN
How does Smartsheet calculate TRIMMEAD (Excel)? Calculating the mean (AVG) taken by excluding a percentage of data points from the top and bottom tails of a data set. Thank you so much.
-
Count of Issues by Month/Year
Hi All I want to add to my summary sheet a count of instances by month and I'm not sure what I'm doing (only 4 hours into using it!) My source sheet has the data formatted UK (dd/mm/yy) and I want to have the summary sheet show mm/yy with the count of instances that occurred within the respective month and year Any…
-
Formula to assign colored dot symbol based on field?
Hello all. I am trying to utilize the colored symbol dots (green, red, blue, etc) while also having a text field specifying what the status of an item is. In my case, I am looking to have the following: Column A (Status) ------ Column B (Status Dot) Available ------ Green Pending ------ Yellow Unavailable ------ Red I want…
-
Workflow email content based on conditions/critieria
Hi All I'm very very new to SS (just got a license today) and I've been included in a team to improve the notification process to our wider audience with key information to help them complete actions quicker with minimum TLDR! Is it possible to take the column header and add the text to the output notification (email) if a…
-
How do I set dates depending on another task being completed?
If we speak with someone that completed a questionnaire we will follow up with them in 28,35,42 days. I am able to set the dates to be prefilled but how do I set the condition that if only the questionnaire was completed or is "green" we should enter the follow up dates? We have a column to show green or red for…
-
Counting Multiple Values in One Cell
Hello, We have a form with a multi-select option for "Event Type". I am trying to create a new sheet that can be used within a dashboard with a chart that shows how many "Event Types" there are within a given "Delivery Format". Snippet of sheet collecting form submissions below. The formula I was using to try and find the…
-
How to Record Data Weekly
Hi, I now have 1 main sheet, and then 4 different sheets where it moves over data to, 4 times throughout the month, using automation to move certain rows by month on the I.e. 7th etc. then I have a dashboard showing the different data of the 4 sheets, so you see 4 times throughout the month how the numbers changed. Is…
-
How to combine multiple IF statements into one?
Hello! I have 3 different IF statements in 3 separate columns that I would like combined into 1 if possible. The three IF statements/columns are the following: Red Status - if task is in the past and not checked complete: =IF(AND([End Date]@row < [Today Helper]@row, [Task Complete?]@row = 0), "Red", "Green")=IF(AND([End…
-
Date column triggering urgency status column
Hello! I have three columns: 1. Date 2. Checkbox 3. Urgency status If the date populated in the Date column is one week or sooner from today's date, and the checkbox is unchecked, I would like the urgency status to be yellow. If the date populated in the Date column is past today's date and the checkbox is unchecked, I…
-
Counting # of tasks from a specific parent
Hi all, I am trying to count the number of tasks in my plan underneath a specific heading. However, I am unsure how to do this for 1 parent heading and not all of them. For example, I am looking to find the number of tasks under plan stage 2. Plan stage 1 Plan stage 2 Plan stage 3 I would use "=COUNT(CHILDREN([Task…
