-
Average collect w/ 3 criteria
I'm attempting to average the %age passed for a specific month and year for a specific team. I successfully used the below to average the total by month and year, but can't figure out how to add the team. =AVG(COLLECT([%Passed]:[%Passed], [Month 2]:[Month 2], =1, Year:Year, =2024) I tried the below, but am getting a…
-
Logging time on hold
Hi, I am looking for a way to log the time a row's project status column is changed to on hold and then stop counting when the status is changed. It would be possible for the project to go on hold multiple times. Any help would be much appreciated. Thanks!
-
Formula SUMIF with date range
Hello, I have a sheet that tracks educational programs: date of the program, # of participants, and content categories for reporting purposes. I'm trying to write a formula that counts all the participants in a specific date range and falls into a specific category but I keep unparsable. Can someone help me figure out what…
-
Complicated IF formula
I am trying to create a column formula that does the following. If the application is Declined or Withdrawn then cost is 0. If not, then based on each course we offer, it puts the cost of the course. This is the formula I have as of right now but it is very messy and not working. =OR(IF(IF(OR([Application Status]@row =…
-
Include "TIME" Function in the "All Functions" tray (in addition to any other omitted functions)
Years back, I learned the functions of Smartsheet by reading, reviewing and then testing all the functions from the "All Functions" tray. However, last night when hitting = and T, I saw "TIME" as a possible function. Not sure long I've been missing this from my tool kit, or what else could be missing. I checked both the…
-
CountIFS based on rolling FY and item.
Hi Everyone: I am trying to count how many of X has been completed (based on completion date) in the current FY based. Ideally I'd like the count to automatically update what the current FY is. I think this should be a simple formula, but for some reason, I'm at a loss. Thanks in advance for your help.
-
Query Formula Help!
I am currently creating a search query that will allow anyone to search for a name and get the corresponding information. For some reason, when I try these different formulas, I am receiving the error message even if the name is correct. I've included my references in the formula as well. Can anyone help with this? Current…
-
Evaluate a date and return week #
I have a date input in a worksheet and need to somehow lookup what week # the date falls in. My weeks begin Monday and end Sunday. Screenshot of 'Date Range' worksheet below. So if my input date in a separate worksheet is 03/15/24 I want to return 11. I am using this in a 'LookUp' worksheet. Screenshot of 'LookUp'…
-
How to create a formula to show last day of the month
I am trying to create a monthly timeline template, where once I set the start date for the project, the 'Billing Month 1 start' column collects the date and the following column 'Billing month 1 Close' column indicates the end of that month. From there The following 'Valuation 1' column is the result of the prorate then;…
-
Inches abbreviated as "
Hello! I am trying to write a summary formula that will count the number of valves by size within a column. My problem is that the size description recently changed from the word "inch" to the symbol " as the inch abbreviation (ex: 2" for a 2-inch valve). My old formula was: =COUNTIF([Valve Size]:[Valve Size], ="2 inch")…
