-
COUNTIFS with a multiple drop down field
I'm struggling with some syntax. I have the following fields: I want to count status by team lead. The team lead is a dropdown allowing multiple entries, status is a dropdown with single entry. I found that it counts Joe, but can't find Jane. I have two references to this table - {Retail - Status} and {Retail - Lead) My…
-
How to count inventory used per day in Gantt chart
Hello, I have a Gantt chart that has inventory requests by location. I am trying to find a way to use the COUNTIFS function to count how much inventory is out on location on any given day. What is the best way to do this? I have been trying to use the Sheet Summary but not having much luck. Thank you!
-
Countifs with multiple criteria in one column
Hello, Trying to use countifs with the first column having multiple criteria. I need the count in {B3, BRIDGE, C2B Subfleet}, =319 or "3HF". I am counting for a metrics widget so I do not want to separate the count. =COUNTIFS({B3, BRIDGE, C2B Subfleet}, =319, {B3, BRIDGE, C2B In}, >=TODAY(), {B3, BRIDGE, C2B In},…
-
Smartsheet not Auto-Calculating
I have a sheet that I am using for metrics to feed a dashboard. The sheet has formulas to summarize data as needed. The formula is linked to the results sheet for surveys. As new survey feedback is received, the formula in my metrics sheet is not updating. The formula worked initially, pulled necessary data, and populated…
-
AVG (days until client) and if
Dear Smartsheet Community, I wonder how I can fix this issue: I want to show in my dashboard the average number of days until a lead becomes a customer. So far, so easy. But I only need the cases above zero days Would it be =AVG(Collect[interested since]; >zero P.S. I cannot put the 2 brackets behind the above formula.
-
Disable summary values on parent rows
Hello! I have set up my project list to contain a topic area (blue), sup-topic area (gray), and tasks. Since the actual tasks are technically "sub-tasks", the data in the parent rows are summary values. This information is not super helpful/relevant, especially the "Health" since it's not a very accurate depiction of the…
-
Flag parent records
I have a column where I flag items that are a risk. I would like parent records to also be flagged if their children records are flagged. Is there a way to do this? Thanks!
-
Dashboard auto color metrics.
Is there a way to auto color metrics (derived from Smartsheet Summary section) percentages on Dashboard ? EX: If the production rate is over the set goal - auto color the percentage number on dashboard to green if not auto color the percentage to red to indicate below goal ?
-
How to conditionally format based on sum of children?
I currently have a meeting agenda sheet. In the parent row for the meeting I'm calculating how many meetings have been reserved for the meeting versus how many have been put on as agenda items. In the parent row I have a formula: ="60 minutes have been reserved for the meeting and " + SUM(CHILDREN()) + " minutes have been…
-
Merge multiple columns into a single column on another sheet?
Hi, I have 3 columns on the same sheet (C1, C2 and C3) and I want to Merge them into a single column "A1" on another sheet. Is this possible in Smartsheet and how can I proceed? Thank you for your help. Best,