-
Adding year to quarterly equation to count
I want to count how many projects in each network have expected completion dates within the quarter per year. For example, in Upstream, I know 3 projects will complete in Q1 2024 but 1 will complete in Q1 2025. The formula I'm using won't account for the year and count correctly for what I know are the actual expected…
-
Is there a way to have text repeat all the way down the primary column?
Is there a way to have text repeat all the way down the primary column, even when new rows are added without having to manually enter? I am trying to use this as a helper column so this is what displays in the calendar.
-
How can I use a function to pull dates from Sheet A to Sheet B?
I have a master sheet of dates for multiple programs and projects. The layout of the sheet is: Program | Project | Start Date | End Date Each program is divided into hierarchies as such: Program A --Program A-1 ----Program A-1 | Project A | Start Date | End Date ----Program A-1 | Project B | Start Date | End Date…
-
Auto Calcuate Due Date Formula
I am trying to calculate a due date based upon a 5, 15, 30 day criteria. The problem I am running into is that the way I have the 1st row of each area setup (it is broken down by equipment, then sub categorized into dates). I have a formula setup to auto calculate the # of days criteria based upon "low, medium, high"…
-
What formula to write - Vlookup or Index/Collect Formula???
Hello, I am creating a New Hire and CFO Buddy Tracker to assist me with paring new hires to mentors within the company. I have two sheets set up one that has the name of all the mentors currently available and another with the list of New Hires. The idea is that on the Mentor list I want it populate with the name of the…
-
Want a formula to autopopulate the task names of other rows
So, I have a project. We have milestones listed at the top, which are not tied to any waterfall style deliverables. They are just each their own milestone, with 0 duration, and manually entered dates. I don't want to create a complex GANTT chart just to get the dependencies between milestones to show. So I am trying to…
-
Im trying to assign a formula only to parent cells, to get % completed
I have a column called "Done" and i want the child cells to have checkboxes and the parents to have the % of the project done( some rows dont have child cells and are stand alone). I have a formula that works: =IF(COUNT(CHILDREN([Primary Column]@row)) >= 1, COUNTIF(CHILDREN(), true) / COUNT(CHILDREN()) * 100 + "%") but I…
-
RYG based on cell value
Hello, I'm trying to set the RYG ball based on the value of a cell and I can't seem to get it right. If the value is: Greater than 0 = Green Between 0 - 0.5 = Yellow Less than 0 = Red =IF(Remaining@row > 0, "Green", IF((Remaining@row >0, AND(IF(Remaining@row<0.50,))), "Yellow", IF(Remaining@row<0), "Red")))
-
Status Formula Explanation
I am trying to figure out how to roll up a status in my project plan. I have been trying to figure it out using this link from the community: Formula to Roll Up Task Status — Smartsheet Community. However, I am getting confused about the "helper" column. If I understand correctly, I need to have a status column where I…
-
Changing a simple Excel formula to work for Smartsheet.
I imported and Excel spreadsheet to Smartsheet and selected to keep the Excel formulas. How ever I get an #UNPARSEABLE. Here is what the formula looks like, =IF(OR([CITY METERSIZE]11="5/8"" BY 3/4""",[CITY METERSIZE]11="5/8""",[CITY METERSIZE]11="3/4""",[CITY METERSIZE]11="1"""),"Small",IF(OR([CITY METERSIZE]11="1 1/2""…
