-
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""…
-
IfError returns "incorrect argument"
Hi, I am trying to find values that exist between two Smartsheets. When it does, I should get a checkbox, and when it doesn't, I would like the checkbox to be unchecked. If I use: =IF(INDEX({Sheet B}, MATCH([ProjDef in ASH Custom]@row, {Sheet B}, 0)) = [ProjDef in ASH Custom]@row, 1, 0) I get "#No Match" when a value…
-
Can you have a column formula in a column that has a drop down list?
Hi Everyone, My dropdown list is not giving me the option to make a selection now that I have a If formula in it. Column 1 = Team (this is a drop down list with the following teams: Career Development, Instructional Design, Learning Solutions, Leadership Development, Talent and Learning Ops & Infrastructure) Column 2 = LDO…
-
How to only Sum values for unique requests with a specific request type
Hello, I have created a sheet to calculate some data points based off of an archive of requests that get pulled from an Automation when Estimated Completion Date and Actual Completion Date are changed, and I am trying to setup a columns to display the Average Days to Completion for each request type to help with estimates…
-
Conditional Formatting - Dates in the past
Hi, I want to add a conditional format on a column holding dates that will highlight those dates which are over three years ago. I thought I would be able to pick "is not in the last (days)" and enter 1095, however it only shows "is in the last (days)" For now I have had to add two conditions: "is in the past" AND "is less…
-
Using a column formula to populate child rows without changing data in parent row of same column
I have a sheet where I am tracking meeting engagements with stakeholders. The Parent Row data is all manually entered and I want the data to autopopulate the children rows of some of the columns (e.g., Sector). I'd like to have a column formula that does this without affecting the data in the parent rows. I have my parent…
