-
Calculate formulas by Columns
I am relatively new to Smartsheet and am stumped on a formula, and so are my coworkers. I do QA for multiple teams and I need to be able to calculate information such as # of Exceptional scores (100%), Meets Expectations (85% - 99%), and Needs Improvement (0 - 84%). We tried Countifs, Averageif, and a few others and did…
-
Counting the number of items due in the next six months from today's date
Hi, I am struggling to find a formula that can count the number of items (each row represents a task/project) that are due in the next six months from TODAY (the date of viewing). At the moment the below formula is incorrect ... =COUNTIF([Target Closure Date]:[Target Closure Date], IFERROR(MONTH(@cell), TODAY(MONTH(+6))))…
-
Duplicate Values causing multiple emails being sent with the same info
So I have a sheet that is essentially tracking missed attendances. And we want to know when a miss happens each time. I have it set up currently to check for duplicates and then a box gets check for each miss up to 3. Then I have a workflow to notify different people based on the number of miss it was. My issue is that…
-
(SmartSheet newbie) Filter and Count across Columns
Hello, I am very new to SS (a day into using it) and I'm not even quite sure how to ask this question. I am trying to create a dashboard to see the total number of different types of positions in my company, with intersecting filters. I have a master sheet with a column for the type of position (Contractor, FTE, etc) and a…
-
RAID Metrics
Hello! I am hoping to get a little guidance. I am a little rusty on formulas and I have been trying to determine the count of "Open" items on our RAID log. We have Risk, Action, Issue and Decision that is a drop down option under our "RAID Type." Our "Status" column has a drop down option of Open, Closed and Canceled. Our…
-
Automatically linking different sheets to a master sheet?
Hi, I am trying to create a master sheet with information I need that pulls specific cell data from multiple different project sheets. I know I can use vlookup's and reference another sheet within them but I'm wondering if there is any way to create a template or workflow so that when a new project is added to the projects…
-
SUMIFS with OR
I feel ridiculous asking a question when I've seen several others on this same topic and I modeled my formula after them. I'm trying to sum an account total when the string matches either of two different strings and the account code matches a different criterion. I'm just getting an unparseable error so I'm sure it's a…
-
Retrieve Date from Data
Good morning gurus! I have a tricky one today. I need help retrieving data from a cell. The column (Routine Execution) contains information imported from another program and looks like this: 5S Audit - Jul 29, 2022, 04:01 PM Gemba Checklist - July 13, 2022 I was able to pull the date from the above data using the following…
-
INDEX MATCH is not pulling correct data even when formula is correct
Hello, for some reason I am having a recurring problem. Well, 2 recurring problems in the same vein. I am trying to pull in data from one sheet to another using index/match. I am positive that this formula is correct because I use it about 100 times throughout all of my sheets. In this particular sheet, this formula is not…
-
Is it possible to calulate average of a time metric?
Hello, I have a column for Avg Handle Time, where each row is formatted as: 0:00:00 How can calculuate the average of multiple rows? I know with Excel, you can just highlight the whole column, and it'll calculate the average automatically. How would this be done in Smartsheet? Thanks in advance, -Cyrus