-
Average Resolution with Date
I have my average resolution for each ticket that is opened, and then i want to reach a summary sheet for each quarter that gives me my average resolution based on the quarter by month - i'm using my resolved date column so its in a date format. This is the formula that I am using, however i keep getting errors This gives…
-
AI won't edit this formula
I need help to edit this formula to include only Designations with a Date of Manufacture (this is the column name) greater than 01Jan2025. I keep getting a request to regenerate the question. =COUNTIFS([Days btw Capping & Mfr Release]:[Days btw Capping & Mfr Release], >60, Designation:Designation, <>"PPQ1",…
-
Checking for duplicates between two different sheets
We are setting up a raffle where we will send out a form for someone to completed to enter the raffle. Once submitted we will take the (Full Name) column and randomly select a winner. We do have a few things on this sheet, we check to make sure there are no duplicates on the sheet, and once a winner is selected and checked…
-
Planned and Actual dates
Hello everyone, I guess (or hope) some of you have used the PMO template that contain these 2 columns, and then it calculates the overall "Health" based on the delay. However, I'm struggling with them and how to update them… Here is the scenario: Let's say that I just created my project plan, so it is easy to set the…
-
When to use = and "" in COUNTIF formulas
I came across some weird COUNTIF functionality recently in one of my duplicate check column formulas. I wrote some exploratory formulas and wanted to share! Key Takeaways Numbers with leading 0s requires both = and "" Regular text requires "", but = is optional Regular numbers do not require = or "", but work with one or…
-
Distinct Numbers
Hello, I have a column "OPRO #" where it lists hundreds of OPRO # with many repeating number. I want to pull the unique numbers and list those in a separate column where each unique number has its own row. I am having issues finding a working formula. Thank you in advance for the help!
-
Pre-Filled Forms Using URL Queries: Tips and Tricks
Using URL queries to pre—fill forms seems to be catching on a bit more lately. There are a lot of resources out there, but they can be kind of spread out, so I figured I would start a thread that has some of the lessons learned, tips, and tricks that I have discovered along the way. Tip #1 The first one that I find makes…
-
Help! Need to match a cell between two dates with complex conditions
Hi, I have a complex formula that i cant seem to figure out. I'll do my best to describe this below In Sheet 1 i have a unique identifier whose condition changes from blue to green after a certain date Unique identifier Condition StartDate EndDate 123456 Blue 1/5/2025 31/10/2025 123456 Green 1/11/2025 I want to ensure that…
-
Need Gov‑Safe Method for Detecting Resource Conflicts (Date Overlap + Name Match Failing)
I'm working in Smartsheet Gov, which has several limitations that don’t apply in commercial Smartsheet (ex: no Manage References, no HAS(), no FIND() in COLLECT, and very strict parser rules). I’m trying to build a “Calendar Conflict” flag in my Project Plan sheet that detects when: A task’s Start/End dates overlap with a…
-
IF, CONTAINS, NETDAYS, AND, CONTAINS
Hi all, Trying to use a formula to work out net days between events in a column (Visit End Date) when a second column (Visit Description) contains "V" but also only if the last visit also contains a V. =IF(CONTAINS("MV", [Monitor Visit Description]@row), NETDAYS([Monitor Visit End Date]1, [Monitor Visit End Date]2)) worked…