-
Weighted Check box's
Just looking to see if there a is a better way to do this. i know i can Write a LONG IF statement to do this. i would like if Step 1 is Check Step Percent would %20 If Step 1 and Step 2 is Checked it would = 75 % if Step 1,2,3 are Checked it would = 95% if step 1,2,3,4 are Checked it would = 100% just looking to see if…
-
SUMIFS - Sum, Restart, Sum Again
Hello Smartsheet Community! I am trying to create a use a SUMIFS formula to add values in a column that are less than 20 within a 7 day range. Once they cross the threshold of 20, the formula should put a checkbox in the row that breached the threshold. Next I want to repeat the process in successive rows, but ignore any…
-
My formulas on my Metric sheet are calculating 0 and I'm not sure why
Hello, I am trying to create a dashboard with widgets to display our overall progression on multiple projects. I was told a Metric sheet would be best to do this. I am creating my first metric sheet but the formulas are calculating 0 and I'm not sure why. In the first section below I am wanting to add up how many projects…
-
Count when 2 conditions are met
Having an issue getting a count when two conditions are met from two ranges/columns from a different sheet. This is what I have but doesn't work: =COUNTIFS([{Serviceability Check Requests Range 2}]:[{Serviceability Check Requests Range 2}], “May 2025”, [{Serviceability Check Requests Range 3}]:[{Serviceability Check…
-
SUMIFS for a 2-Dimensional Array
Hi there, I've got a sheet [Sheet A] that needs to summarize another sheet [Sheet B], where each row on Sheet A needs to reflect a column on Sheet B. I can do this very easily with a SUMIFS function. e.g. Sheet A Row1 =SUMIFS({Sheet B column 3}, {Sheet B column 1}, "example", {Sheet B column 2}, true). The issue with this…
-
Help with Cross-Sheet SUMIFS Formula for Multi-Select Column Reference
Formula Tried: =SUMIFS({Sheet - TCO Cloud Cost Savings Monthly Savings}, HAS({Sheet - TCO Cloud Cost Savings Business Application}, [Business Application]@row), {Sheet - TCO Cloud Cost Savings Savings Status}, "Complete") Error: Incorrect argument set I'm trying to create a metrics sheet that sums values from another sheet…
-
COUNTIFS Struggle – Need a Hand!
Hi everyone! I'm looking for some help with a COUNTIFS formula. I'm trying to count how many contractors vs. employees we have on a sheet. Counting employees was straightforward since there's only one type. However, there are multiple types of contractors, and I'm not sure how to count all of them together. I've attached…
-
Sum If Formula using Column with Multi select drop down
Hello, I am looking for the formula to sum a column (Work Stream) with specific text. The column is multiple select drop down. The drop down options are Available, Unavailable, Assigned and R&R. I need to sum all the rows that contain the drop down option "Available", even if they may contain other drop down options. I…
-
I am trying to build a Sum If with a cross sheet reference but can't think of the formula.
I am trying to build a Sum If with a cross sheet reference to where IF a plant is __x__, and IF the end date was within this current month (not last 30 days, current month), then it will add the values in the actual value column for that plant on a metric sheet. How would I set this up/ what would that formula look like?
-
INDEX COLLECT MAX
=INDEX(COLLECT({Nature of Issue}, {Nature of Issue Count}, MAX({Nature of Issue Count}, 1), {Site Name Helper}, Site@row), 1) Hello, community. I am trying to solve following. I want my formula (above) to return the nature of issue that has the most common nature of issue count for each site {Site name helper}. It is not…