-
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""…
-
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…
