-
How to extract just the month name from a date
Hi all, I'm trying to extract month name from the date column. It has been giving me an error. Any input will be highly appreciated.
-
If Contains Contact Cell
I am trying to write what seems like a basic formula, but I'm not getting the expected result. I would like to reference a Contact Cell column with an If(Contains) formula. The basic formula I have written looks like this: If(Contains("John Smith", [Received By]@row), 1, 2). The result is always returning false ("2") even…
-
Pull info from another sheet based on 2 criteria
I'm trying to pull in hours to what I'll call Sheet 1 from Sheet 2. I have flexibility in the way I set up Sheet 2, but I need Sheet 2 to be able to have various employees use the same project number. This would be one option for Sheet 2: In sheet 1, I will have the project number listed in a column, but will only have the…
-
Calculating % of completion based on start & End dates
I'm looking for a formula that calculates the % of completion based on start and end dates
-
Count if Container Code is Unique
Hello, I have a metrics sheet that is referencing another sheet to count how many counts of a specific Hold/MECQI Reason =COUNTIFS({Hold/MECQI Reason}, CONTAINS("incorrect container", @cell), {Hold Issuance Date}, >TODAY(-180), {Hold/MECQI Reason}, NOT(ISBLANK(@cell ))) I only want it to count if the corresponding…
-
Sort Formula issues
Hi, This formula causes a #unparseable and can't figure out what is wrong: =IF(Description@row = "Overall Project Risk", "0-00", IF([RAID Type]@row = "", "", IF(Status@row = "Complete", 7, IF([RAID Type]@row = "Decision", 1, IF([RAID Type]@row = "Issue", 2, IF([RAID Type]@row = "Risk", 3, IF([RAID Type]@row = "Action", 4,…
-
Combine results of multiple COLLECTs? Or alternate strategy?
I am trying to get a count of trainees in my app, each trainee has a unique "Member ID". A trainee is defined as meeting one or more of the following criteria: has a value of "Submitted" or "Issued" in the "Status" column of the "Reimbursements - Approved" sheet has the current grant year (e.g., "GYr 4") in the "Mentee"…
-
Can you use the HAS function in a COUNTIFS formula?
Based on what I read about HAS Function in the Formula Basics (HAS Function | Smartsheet Learning Center) I should be able to use HAS with COUNTIFS. When I try to use it in a sheet, I receive the error message: The formula cannot be generated because the HAS function is not supported in COUNTIFS. The formula I tried is:…
-
Formula Functions causing cell references limit error?
Hello, I'm trying to determine which FUNCTIONS I'm using in column formulas of a program schedule sheet that may be causing too many cell references so that I'm going over the limit of 25 million references (when I have around 3000-4000 rows). Most of my formulas just have @row formulas, but I don't know what some of these…
-
Counting quantities from another sheet that correspond with a reference on original sheet
Hi folks Really need siome guidance. I've tried the AI tool, but not getting anywhere. We are carrying out a network audit at multiple sites. I need to be able to display the SUM from another sheet when it meets the critera from current sheet: For example, I want to bable to display a summary of additiopnal switches needed…
