-
Boolean Expected
=COUNTIFS({Client Name/Planter Location}, Client@row, {Bed Plants (Early Spring)}, 1) I'm trying to match a name on a current sheet with that on another sheet; and on the other sheet, the name may appear multiple times with one or more checked boxes under Bed Plants Early spring. The results are: a box gets checked or i…
-
Gantt View/Schedule W/out Weekends
Hello, I am making a construction schedule for one of our projects and I cannot figure out how to disable the weekends. The 'Duration' column is the one that gets manipulated. I want it in a way that both 'Start' and 'End' columns update based on the inputted duration. and 'End' columns get automatically updated based on…
-
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…
-
Circular Reference Issue
We have had the same worksheet for over 2 years and this past week, we started getting the #Circular Reference Issue. We have trainings and update our employee database (2nd screen shot) weekly and this week the "Clock No" column in the training database worksheet (first screenshot0 in the "Clock No" column is coming back…
-
How do I use Cell reference in a formula when using Index?
I have a simple table that has the following columns (along with other columns), ZZZ YYY 10 15 and I would like to replace the ZZZ and YYY in the following formula =INDEX([Thing1]ZZZ:[Thing2]YYY, 1, 1) With the data from the columns above so that the resulting formula would be: =INDEX([Thing1]10:[Thing2]15, 1, 1)
-
I want to know the formula, if I want the total breakdowns from 1/1/2025?
In my sheet, I have a "Job" column, where it indicates if it was a breakdown or installation. I have a "Date of Job" column, but this goes from 2022. My goal is to calculate the total breakdowns for every year.
-
Countifs/Sumifs with multiple criteria which reference another sheet
I'm trying to make a Metrics sheet to use on a dashboard. I would like to count all of the instances of each (text) heading which fall during this month, then a second column for last month. I can't get the dates to work so I created helper columns with the month, year, and month+year combined (ex April 2025 would be…
-
How to use INDEX function to copy a column from one sheet to another
Hello, I'm trying to copy a column of dates from one smartsheet to a different smartsheet. I'll call the source sheet "A" and the copy to sheet "B". There are several columns in "A" and I just need to copy one column with dates into "B". Also, I would like the B sheet to update when a new row is added to sheet A. I've…
-
Why does Countifs doesn't work in some scenarios in some smartsheet.
I used this formula in one of the rows and it gave me the correct answere after I matched the range by using IFERROR in the columns of count. But the same in not working in another row. Can someone help =IFERROR(IF(COUNTIFS([Rack Suffix]:[Rack Suffix], [Rack Suffix]@row, [Rack Readiness]:[Rack Readiness], "=In Progress") >…