-
Is having multiple 'events' on the same row or specific days highlighted possible on Gantt view
I'm creating a Gantt chart to monitor and plan my progress for a thesis I am writing. I have the various stages of my thesis with their sub-projects indented under them, so my Gantt chart is becoming quite tall. I also need the days of my other deadlines highlighted on the Gantt chart, so I can see where my deadlines will…
-
How to add new sheets/dashboard to all existing projects on Control Center
I have created/provisioned a few projects on Control Center and realized that we wanted to add couple more sheets and dashboards to all new projects as well as to all existing projects. It doesn't seem like the Global Update can achieve this as it can only edit information within a template in the blueprint source folder…
-
Single-Select drop down menu autofilling options
Hi, I am attempting to select an option from a single-select drop-down that will auto-fill the next column. I have loaded the formula as a one to one basis, i.e. if 'this person' is selected, populate 'this manager' in the next column. However, I need it to be across multiple employees. So if, this person, this person, or…
-
Move Rows Automation - Intermittent
Hi, I have set up move rows automation on a couple of sheets so that once a project is cancelled or complete the row is relocated to either a cancelled or complete sheet. Today I noticed that a couple of rows correctly indicated Complete but had not been moved. As I test I used a separate sheet to trial the automation, for…
-
Trying to combine an IF statement and an OR statement and NOT(ISBLANK)
I am trying to utilize an IF statement and an OR statement. I am able to successfully make each statement work independently but when I put them together it doesn't work for me. I am hoping someone can look at each of my statements and see what I am missing. I think I am on the right track but I keep on getting an Error…
-
Fixed Cell Reference
I have search the db for answers but likely have my terminology mixed. I have a sheet which is populated by clients via a web form. New entries appear on the 1st line. I want the value in 'Bears 1' to populate in another sheet or on the same, doesnt matter. The specific cell is key as this is the most current value.…
-
Exporting only parts of SmartSheet to Excel
I have 5 project phases 1 thru 5. Each phase has the same deliverables. I have a Smartsheet with the list of deliverables for all phases numbered e.g. 1.01 for phase 1, 2.01 for phase 2..... 5.01 for phase 5. See attached example. I want to export to Excel only all the deliverable for a specific phase e.g. 2.01, 2.02,…
-
Colour grading
Hi all, Is there any way that i could, based simply on ascending order of numbers, colour code a full column, as i have in the picture below? Thanks.
-
Report not Matching Formula Issue
Hi, I have created a report to use on a dashboard for showing the number of job cards to print for our workshop. The report is shown below, and you can see that there are different amount of jobs to be printed for each workshop: You will see on here that there is: * 3x for the FASTRACK Workshop * 10x for the Van Workshop *…
-
Level 1 task shows delayed (Red) but all level 2 tasks are on schedule
See sample below. How can I fix the formula, or what should the formula be?