-
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"
-
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}} -…
-
Copy the most recent application cell data from another sheet
I have a master sheet with promotion applications linked to a SmartSheet form. Each applicant is identified by a ID number. There is a second sheet with the managers evaluation form. I don't want to send an update request or approval. I then want to copy the cells from the managers evaluation back in on the same row as the…
-
Formula to Automatically Calculate Remaining Budget Based on Multiple Conditions
Hello Smartsheet Community, I'm trying to build a formula that automatically calculates the remaining budget for a project based on several conditions, and I'm running into issues with the logic. Scenario: Each row contains: Approved Budget Actual Cost Project Status (Not Started, In Progress, Completed) Department I want…
-
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…
-
Exclude canceled tasks from the automatic calculation of the parent's % complete
Hello everyone, I'm working on a project sheet (with dependencies enabled and the Gantt view) and I'm looking for a way to exclude canceled tasks from the automatic calculation of the % complete on parent rows. My requirement : When a child task changes to “Canceled” status, I want it to no longer be included in the…
-
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…
-
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.