-
How to create template dashboard and summary grids with formulas?/ Is it possible?
I need to create a set of templates that are personalized to our needs. The needs are the following: - We have a template that is pre-set with column names that is populated by us. 1. From this template after it is populated I need to create a summary template in a grid containing formulas. 2. From this Summary template I…
-
AVG Collect adding Month and Year
Hello All, I am looking to average a Likert scale question of 2 hospitals together, from my list of 9 hospitals. How do I add the month and year so I only average the score for January 2024 =AVG(COLLECT({Question 1}, {Hospital 2}, "Hospital A", {Hospital 2}, "Hospital B")) I have done this in the past,…
-
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'…