-
Smartsheet PMO edits to form and error
I've been utilizing the PMO template with no issues. This week when I try to connect the Project ID and Project Metadata it gives errors for invalid data. We've made no other changes but did make changes to the project intake form. Can anyone explain why and how to fix this?
-
Need help with COUNTIFS formula
I am trying to get a COUNTIFS formula to only count values in column "Status" that contain "To-Do" or "In Progress" where the "Days Aged" column is greater than 14 but less than 31. This is the formula I am using =COUNTIFS(Status:Status, "To-Do", [Status]:[Status], "In Progress", [Days Aged]:[Days Aged], >14, [Days…
-
Start dates and status formula
Hello Community, I am attempting to write a formula that automates my task status based on the date and current state (Started, Not Started, Complete".The columns are 3=State, 4=Status, 5=Start Date, 6=End Date. I want the status to change to Yellow is the task has reached (or passed) the Start Date and the Status is "Not…
-
What equation should I use for a floating Quarterly budget total
Hi Smartsheet community, I am hoping to get some help with solving for a current and next quarterly budget for each of my projects. I am hoping to make it so that the next quarter and current quarter change as the next quarter turns into the current quarter. I am adding it to my project dashboard which is the photo that…
-
Cumulative Count for Various Cells in a column
We have to keep track of daily mileage for our fleet vehicles. I am keeping monthly totals which are calculated at the end of the month. They are based on the driver's daily entries. I want the monthly mileage to be cumulative as the month progresses. But I also want to keep a yearly cummulative count as well. Right now,…
-
Formula Term convert to a given value
I have a Program stage column that has 8 different stage option. In another column I would like to create a formula that based on the @row stage a given number would be indicated. Example: Stage 1 would give 0.2, Stage 2 would give 0.3 and so on. I can use the IF but after two Program stage the formula stops working. The…
-
percentage calculation in a metrics sheet
I have a Metrics sheet where I have a count of the number of shipments that are early, ahead, or behind shedule. The count formula that is giving me the number of shipments ahead or behind is as follows: =COUNTIF({FCA Shipment Metrics Tracker Range 1}, <0) I need a way to calculate the percentage of total shipments that…
-
Help with writing a formula to show Completed and Past Due along with other status.
Hi there, I am able to get all the status to show correctly, except the 'Complete' and 'Past Due', I know its something simple and I am just not thinking of it, help is appreciated! I am using a 'End Date' and '% Complete' Formula used on the 3rd date down =IF(OR([% Complete]@row = 0, ISBLANK([% Complete]@row)), "Not…
-
Sheet Summary counting a name in a contact list column
Hello I have a relatively simple request. I am trying to count the number of times a name is in a column for a Sheet Summary. The Column Type I am referencing is a contact list. I need it to count the name regardless of how many other names might be in the cell. I keep getting 0 as my result even though the name appears…
-
FORMULATE FOR DAYS
I want a formula that will capture network days between dates but that will count only if cell has a date entered. DEPT DATE-1 DEPT DATE-2 RETURN DATE TOTAL TRAVEL DAYS 5/10/2025 5/20/2025 5/30/2025 7 5/10/2025 5/30/2025 The formula should into the TOTAL TRAVEL DAYS Column and will count days based on following scenarios:…