-
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.
-
Sheet Summary Average for last 180 days
I am trying to make a sheet summary that will give me the average of column "# of Days Open" if column "Date Entered" is equal to the last 180 days.
-
countIFS/COUNT COLLECT
the first screenshot below is picking up the month number the stage is against the project name (primary column) pls scroll down the second screen shot below is my set up to try do a count function against month numbers I am failing to get the correct count function for this sheet im trying to make it dynamic rather than…
-
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…
-
Countif Formula Addition - Exclude Value from Another Sheet
Hi all, I was wondering if anyone can help me and apologies if I do not explain this very well. I am trying to make an addition to an existing formula, to exclude a value from another sheet, but still count blanks. Current formula under 'Total Perm' column on main sheet: =IF(OR([Perm Promo]@row = "No available promo", [Max…
-
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",…