-
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?
-
Help with COUNTIFS Formula
I'd like to count if the priority = high and the status = final version In other words, what is the total number of rows that equal both high priority and final version?
-
Pull Data from Master sheet to another sheet
Hello, I have a master vendor list sheet that contains a checkbox column for vendor type. I would like to create a new sheet that pulls over just the vendors that have the vendor type column checked. I need a separate sheet so I can use it for widget in my dashboard. I don't want to filter or sort the main master vendor…