-
Formula: Adding Time
"Hi there, Just to provide some context, I'm currently working on creating a metrics sheet, and I'm looking to aggregate all the hours based on the Legal Team Member." Formula's I have tried: =HOURS(SUMIFS({SLA Hours}, {Legal Team Member}, "John Doe") * 24) =TEXT(INT(SUMIFS({SLA Hours}, {Legal Team Member}, "John Doe") *…
-
Child Parent Formula Help
I want my formula to look at the child count column and if it is great than one to run a sum of the children rows and if it has 0 children to run a lookup SUMIFS formula: I was hoping it would work like this but I keep getting errors. =IF([Children Count]@row > 0, SUM(Children()), SUMIFS({Curo.Points}, {Curo.Category},…
-
Calculating Previous X Weeks at the New Year Turnover
Hello, I've got this handy formula calculating if a row record is from the previous 5-weeks that worked great up until the new year. Now I need something to know that Week 1-2023 and Weeks 49-52-2022 are what should be considered. It's probably not as hard as I'm making it out to be and I'm sure someone has run into this…
-
Determine if a reporting month is past, present or future
I have a project budget sheet, with a column for each monthly reporting period. I have a row that determines the actual month for each period, based on the starting date for the project. How do I determine status row if the if the reporting period is in the past, current or future?
-
Formula to look up matching columns and return populated fields
I have two Smartsheet's. The First Smartsheet contains all the original data. The Second Smartsheet will contain unique values from one of the columns (the column with a 1 in the IDUn... column). In the Second Smartsheet, I need formulas in the individual column row fields to look up and match the value in the IDUn...…
-
Sequential numbering not working (Project with WBS sheet)
Hi All, I am fairly new to Smartsheets, so please be kind :) I am creating a WBS with the Template the Smartsheets provides (Project with WBS sheet), but I am noticing that when I add new tasks between other already created tasks, the numbering goes all wrong. Also, Even if I add more tasks underneath, the numbering is not…
-
Incorrect argument set error message on countif formula
I'm working on a project that distributes free car seats and we collect data from family members for up to 4 children per family depending on their car seat needs. One entry may include 1, 2, 3, and/or 4 children and we ask for specific demographic data per child. Again, all collected in entry so across multiple columns…
-
How to compare form responses with a list of emails?
Hi! I have created a survey/form and emailed it out. One of the survey questions asks participants to enter their email address. How can I compare their responses to the list of emails I sent the form to? I would like to create a report that shows who has responded and who has not based on the email addresses.
-
Determining Count of Items in a column based on Specific Dates
As the title suggests, I am trying to determine the number of Active Projects, based on status, on a monthly basis. I am not basing my logical expression based on a date criteria in a cell; I simply want to see: Active Projects (based on a status of: Not Started, In Progress, On Hold) Jan 01 to Jan 31 (as an example; would…
-
Countifs, Date Functions and Text Criteria
I am putting together two sets of formulas so I can capture the number of tasks within a certain year and month, and another set to see which of those are completed. My formula that works to capture the number of tasks is (in this example, January 2024: =COUNTIFS({GA Date}, IFERROR(MONTH(@cell), 0) = 1, {GA Date},…