-
Helper Sheet Help
@Andrée Starå has mentioned on multiple posts about creating Helper Sheets when trying to manipulte data to have certain rows copied to other sheets. I'm completely stumped where to start with the cross-reference formulas to make that happen. I have a master sheet with a lot of columns, some of the data in the master needs…
-
Automated Reminder for Approval Request?
Hello, Is there an easy way to send an automated reminder based on an approval request? We automate approvals from some of our Smartsheets and would love for a reminder to be sent x days later if the approval status is still "Submitted". I can't find where I can build a reminder based on the status change plus a number of…
-
Linked Cell Not Working
Hello! We are linking cells from a project plan to a master sheet. Every other cell in the row linked just fine, except for the last one. It says that it is linked, but no information is being pulled into the cell. The cells in the project sheet are filled out and linked out to the master sheet: These are the corresponding…
-
Curiosity: Best practice use of symbols for health on projects
Hey all, I'm curious as to how others are utilizing the symbols for project health when tracking health task-by-task in a project. If you are using RYGB or RYGG, how are you indicating future state tasks? Gray or Blue is being used to indicate "Not Started" tasks or future state tasks Gray or Blue is being used to indicate…
-
Is there a way to create a 'collapse section' on a Dashboard?
I'd like to truncate the Dashboard view for my users so that they can select what they want to see by Section Content (eg Project Progress, Project Resource Links, News/Updates etc.), instead of everything being available as a huge data dump a mile long. Is there a functionality to expand/collapse sections on dashboards…
-
Copy&Paste with relative predecessors
Hi, I have a schedule (created from Project template (aka Gantt chart)) where I have a section which is repeating several times in the schedule. Inside of a section I have dependencies linked using Predecessor field which do not point outside of the section itself. You can imagine this as an agile sprint schedule where…
-
If Comment is not blank, then show the recent comment and date
Hi everyone, I have a Follow Up Date column and a Comments column. I have predetermined dates under the Follow Up column. I would like a formula to populate the most recent Follow Up Date and the corresponding Comments on the parent rows only if the Comments are not blank. Any help is appreciated! Thank you!
-
Reference cell in column on one sheet, against column on another.
I am trying to create a formula thagt will look at the "Item Name" columns numbers, and then check to see if any instance of that number appears in a column on another sheet, and if it does return "True", and if it doesnt return "False" I've had a similar equation in excel "=NOT(ISERROR(MATCH(A2615,'Up-To-DateLK'!A:A,0)))"…
-
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…
-
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…