-
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
-
IF formula correction please
Hi There, It is a Monday morning for me and a distinct lack of coffee means that the above formula is likely an absolute shemozzle. Essentially I am trying to return an argument that says If the Priority rating shows this (eg H5) then return this number (eg 15) in the helper column. This formula (once correct!) then also…
-
Formula: Counting Cell Values with symbols
Hello, I have a formula to count the entries for "Actual Hours" within a date range. For one of the values "<.5" the formula returns zero. I've tested a change to "lessthan.5" which counts as desired. I went back and ensured there were no erroneous spaces in the "<.5" value entry. Is this a limitation with formulas or have…
-
Unmark a checkbox if any instance of another sheet's checkbox is marked
Got a knotty question that I'm sure the savant's here can solve, as I am a novice at column formulas. The issue? We'd like to track average hours worked across multiple employees, however we don't want the employees who are currently training to dramatically offset the data. Thus, we'd like to check a box indicating that…
-
Help displaying a value present in another column if both conditions are met.
I've been trying to create a formula that will display the Remaining fifty percent when I meet two conditions. Set up to be billed has to be 50% and Live Date can't be blank. If both are true, then display the Amount due for Integration. I have tried to use If and If Contains to no avail.
