-
VLookup, Index, and multiple criteria
Hello all- I am trying to return a value from one sheet on a summary sheet based on two different criteria. I have attached a couple of screen shots. If the YMCA Name on the "Summary - Association Attendance by Committee" sheet equals the YMCA Name in the row of the "Summary - Association Grid" sheet, return the %…
-
Max(Collect formula
I'm trying to pull in the most recent date of a file, and it looks like =Max(Collect is the way to do it, but I'm having trouble with getting the formula to work. Currently, I have =MAX(COLLECT({Date of Recent Update}, {Parent Folder}, [Delivery Path]@row)) where Parent Folder and Delivery Path would be the reference to…
-
How to Count Requests Submitted within a Certain Time Period
Hi! I am using a Smartsheet Form for users to submit requests to my team. I have a column that automatically generates when the request was submitted (month/day/year time of day). I need to be able to count how many requests we are getting for each hour of the day to justify shift hours for my team. Is there a way to…
-
Create Percentage Based off # of Checkboxes Checked
1) Creating a percentage to tally how much out of each section is checked completed. 2) Then also need to setup a formula to do the same for the overall sheet including all subheaders. This is the formula I have so far for the individual subheader sections. But I keep getting Invalid Operation errors. Not sure what I'm…
-
Trigger when a cell is updated
I am looking to set up a single notification when a change is made to a field on a datasheet. I have set up the trigger below, but every 5 mins I'm getting duplicate notices. Can someone help direct what I am doing wrong to trigger a single alert when a change occurs? Let me know, Dave
-
Conditions Met Totals
Hello, I have each column set with conditions. If they are met, they highlight a certain color. In this Lanes Won column, I am wanting the total of the conditions met per row. What formulation should I use? Row 1 should be 2 lanes won. Row 2, 1 lane won. Row 3, 0 Lanes won. ect..
-
Status Symbols from Multiple Date Columns
I'm looking to have a health status (green, yellow, red) populate by checking multiple columns with differing expiration dates. I'm trying to come up with a formula that will return the following status': IF[Orientation Date] is in the past and [First Aid Ex Date], [OTS Exp Date], [BBP Exp Date] are at all least 30 days in…
-
How can I get the Overall Project Health based upon Health Column
I have to create a project and I need to have overall health of the project included in the sheet. I have a column that is titled Overall Health, and another column titled Health. Health column has several tasks under it which some health status are green, a few yellow, and a few red. I would like for the Overall Health…
-
IF Function not returning as expected
Hello I have an IF function I am trying to run that evaluates a cell, and then returns one of two indexing formula results I have verified that each indexing function and the If function itself with different results all seem to work. But when I plug them together, my IF function stops evaluating "3100" properly, or it…
-
Complex Data transfer based on submission date
Hi there, I'm working on a reporting & tracking system that was originally set up in MS Access. The current process is very manual for the Ops person, so I'm trying to see if SS's automations & forms will work. Each team gains points throughout the year based on when things are submitted. As there are 30+ teams, I've…