-
Copying Row and Keeping -Hierarchy Parent/Child relationship
Hello I have to copy rows from one Smartsheet project another Smartsheet project plan that has a lot of formulas, links and automation built into it. Is there anyway when I copy the rows over to maintain the parent/child relationship? All the information copies over fine but none of the parent/child relationships remain in…
-
AUTOMATE PROGRESS BAR BY MULTIPLE CONDITIONS
Hello, I am trying to automate my progress bar, basing it's progress on multiple conditions. I have 10 columns I would like the progress bar to consider. Example below of how i would like it to work: If Cost 1 AND Hours 1 IS NOT Empty then progress = 25% If Parts AND Survey AND time IS NOT Empty then progress = 50% If…
-
Schedule Health based on End Date, Target End date and Todays date.
Need a formula for schedule health based on these conditions Schedule Health- Red: When end date is greater than target end date and in case end date is blank, it should turn red if todays date is greater than target end date Schedule Health - Yellow : In case end date is left blank and target end date is in next 4 days…
-
MAX/IF +1 Formula
Hello, I have a sheet for our job lists, we have 3 different types of jobs, i am trying to write a formula that will pick the next highest number in each of the sections My work flow, is chose "type of job" and that will generate 1,3 or 5 in "job classification", i am looking to pre populate the Job# with the next highest…
-
INDEX consecutive row indexing
I've had this issue come up a bunch for me when trying to write formulas. Say I've got a column of Order Numbers that have a lot of repeated numbers in it. I can write a formula to pull out distinct numbers into another sheet such as this formula: =INDEX(DISTINCT({Order Number}), 1) However, that's only going to pull out…
-
Convert Days to Year, month
Hi I am using this Formula =(TODAY() - DATEONLY([Appointment Start Date]2)) to give be days from a date started to today. The answer gives me a whole number eg 830 Days. How can I convert the days to Years, month while still using the above formula??
-
Index Match Returns Blank Issue
I have an index match situation where it is returning blank and I need help troubleshooting this one. Any help would be greatly appreciated! Here are my steps: 1) On the top sheet I am removing spaces in the text from "Name" column to "Condensed Name" column. =SUBSTITUTE(Name@row, " ", "") 2) In Template - Deliverables…
-
If a certain drop down is selected, how do I auto populate an Inform column with the name assigned
I tried using a helper column with names in it that I intended to hide. So if the Escalation Type column allows Care Concern that Cori works on and Bluetooth Activation Issues that Marla works on- how do I get the Inform column to auto populate to Cori or Marla's name? I tried =IF([Escalation Type]="Care Concern",[Helper…
-
How to write a formula with multiple conditions?
Hi, I have these 5 Phase columns in my project tracking sheet. Now i want to automate the column named "Test" that shows at what phase the project is currently in. The logic is something like: "If the Phase 1 is 100%, Phase 2 is 45%, Phase 3 is 65% then the project should be at Phase 2" Ideally if the phase is at 100%, It…
-
How to apply a priority countif formula to specific rows based on cell criteria?
Hello, I am using the following formula in a priority column to maintain ranking number when filtering my sheet. I would like to apply this formula to the rows based on criteria in my "Open, Backlog, Closed" column. For instance, if a closed is selected for a row, i do not want the formula to apply to that row.…
