-
Average formula - count dates
Hi, I have a column named "Applied" which has dates of when an application was submitted. there is another column called "HR Review Time". the HR review time has numbers. i want to make an AVERAGE of the number in the hr review time column for dates 11/11/23 until 11/10/23 in the applied column I created this formula but…
-
SUMIFS Formula Reference Another Sheet
I have a budget sheet that I want to pull total monthly expenses from another sheet. The below formula is calculating the total [Health & Safety] spend, but I want it to only calculate expenses for June. I have another column which picks up the month from the date column. I am wondering if it is a SUMIFS formula and I need…
-
Searching keywords from a list of words?
Hi, I have two sheets, say Sheet 1 and Sheet 2. Sheet 2 contains a list of words in one column (i.e. "Keyword"). Sheet 1 contains a column with status updates (i.e. "Comments"). I would like to set up a formula that searches if Sheet 1's "Comments" column has any matching keywords from the list of words hosted in Sheet 2's…
-
How to show % complete compared days in a year
Hello, I'm new to Smartsheet and I've built a few widgets but I'm currently having trouble with one I'm trying to build. I'm trying to create a widget to show the percent completed of a project compared to the year completed. I have several projects that are needing to be added up to show a % and want to compare that with…
-
Calculate the fiscal weeks between two dates
Hello, I am trying to get a count of active employees for each fiscal week between two dates. Every week the count fluctuates, and I would like to create a chart to track the fluctuations. I have a project intake sheet that has start date, complete date, Techs Assigned, and customer. The projects last multiple weeks. How…
-
Nesting IF, AND, and OR
Hello there! I am working on a project that will allow us to do a very quick visual check when a date is inside a work window. The problem occurs when a work window has two date ranges, this example being 07/16 to 07/30, and then another work window between 11/15 and 02/01. Not all work windows have two work windows, but…
-
Count Providers Who Make either Pediatric or Perinatal Call
I am attempting to count the number of providers who make either a pediatric or perinatal related call. I have this formula: =COUNTIFS([Provider Name]28:[Provider Name]38, OR([# Pediatric Calls]28:[# Pediatric Calls]38, >0, [# Perinatal Calls]28:[# Perinatal Calls]38, >0)) I keep getting an #INVALID error.
-
Summy Sheet Formula
Hello, I have been working on this two long. I'm trying to use I thought a simple countifs formula to count the number of "coming due", "not started" & "on track". each will be it's own formula however I keep getting invalid operation error. It's driving me crazy please help. What am I missing here is the not started…
-
When a row is created, how can I tell one of the columns to add today's date...
So I'm using Unito.io to pull data from DevOps, and I need to know when the row was created ( Not Updated ) in smartsheets. So, I looked at using the "auto number," but there is no way to tell it to use the date. Can someone help?
-
If values are there in a cross sheet, Populate cell
I need a sheet to populate off the values of another sheet IF the site code is in both then i want the site code to populate multiple rows in the collumn with information IF ABC1 has 1 Charger Populate cell 2 If ABC2 has 1 charger Populate cell 3 I want this to be done fully automatically without having to put in other…