-
Numbers Only Formula
Hello, I am trying to have the column "Order/Job #" automatically populate the 6 digit number of the parent row in the column "Customer or Task Name". So basically in the screenshot below, in the WHITE row, column "Order/Job #", it would say 661181. Basically, there will be multiple children rows under each parent, and I…
-
Use SUMIFS referencing start and end dates from another sheet
Hello, I have three sheets. The first one has four attributes (Let's call it Main): [ID, Observation Date, Group, Count] The second one has three (Let's call it Week): [Week ID, From Date, To Date] The third has all the Groups listed and the corresponding weeks where the counts will be displayed based on met criteria…
-
Partial Vlookup
Hi, I need to lookup partial value and map the tagging. There are 2 sheets, main data sheet which is connected with lookup sheet to fetch the Tag. Wherever complete match is found, tag is fetched but i also want to fetch tag in case of partial match i.e. Row3="Yellow" (as DE19-1121 in lookup sheet says Yellow which is also…
-
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…