-
Matching Values from two multiselect columns
Hello, I have in an intake sheet two multi-select columns - Carriers and ASLOBs. In another reference sheet I have a matrix where I have combinations of Carriers and ASLOBs with a matching Operating Company. What I am trying to active is: Match first value from Carriers column to first value from the ASLOBs column and then…
-
Report Inquiry
Does anyone know how I would organize a report sheet by date instead of by project number ? I wanted it to be in date order instead, oldest - newest. Any help is greatly appreciated
-
Hey! This is the Report Format I am hoping to have auto populated through 3 forms multiple times a day. I would love some help building this form.
-
AI for formula is not working
I would like to make the following into a formula, and tried using the formula AI option, but can't get the formula to work! "If the number in Site column (on 123 sheet) matches number in Site Number column on ABC sheet, and meeting date on ABC sheet is in the past display "1"
-
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…
-
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…
-
Counting Number of Tickets Between Dates
I am trying to count the number of tickets between dates that are client facing only; everything i've researched brings me back to this formula, however I keep getting #UNPARSED and i cant figure out what is wrong =COUNTIFS({ReportedDate}, ">="&DATE(2026,4,1), {ReportedDate}, "<"&DATE(2026,7,1), {Category},…
-
How to make dynamic placeholders stop duplicating down email
We have an automated report that sends out once a week using dynamic placeholders in the email automation. everything is working mostly as it should however we cannot figure out how to get one of the placeholders not to copy down the whole email. The placeholders we are using are {{Start Date}} - {{End Date}} {{Agent}} -…
-
Need help with formula to pull list of chapters that are past due
Hello, We use very large SS and I'm trying to fully automate our status reports. In our Schedules for each chapter we have 3 rows of data, planned/revised/actual. I am wondering if it's possible to write an equation for each column that would do the following: Look at the same chapter number rows If the planned date in the…
-
Populate a row with the last Friday of each work week for the year
I'm creating a Weekly Hours Tracker for our projects with each week having its own column (W1-W52). I want to populate the date for each week (row 10) as the last Friday of each workweek for the entire year without typing it manually. The columns (W1-W52) are Text/Number, not Date.