-
Prepopulate Form for Update Request
We use forms to get information from our colleagues and we would want to send them a form prepopulated by their inputs so they can update the information if there are any changes. This would be very useful if we can automate the process and make the items mandatory
-
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…