-
Adding column of summary date values
I have a "Date Completed" column in my list that I would like to roll up like Start and Due Date do with sub-tasks in the hierarchy. I have been unable to figure it out with formulas. So, I am looking for the last date entered in "Date Completed" of a sub-task to auto fill that same date into the highest level of the task.
-
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 *…
-
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…
-
Conditional Formatting based on system columns (Attachments and Comments)
I can't find any discussions on this. I'm looking for conditional fomatting based on two of the three System columns: Attachments and Comments. These are not available today when trying to add conditional formating to a row. For attachments, I would like the criteria based on: - Changed: If the list of files has changed at…
-
Is it possible to apply Conditional Formatting with a formula?
In Excel we have the ability to use custom formula for conditional formatting, is this possible in SS? Please see screenshot below. I need to compare column values to the value at the top cell. I can do this by adding more columns and formulas and then hide them, it would be cleaner if I can do with conditional formatting.…
-
Conditional Formatting for Kanban Card View
When looking at items in Card view, conditional formatting is an option but you can't apply the formats to the card view itself. Is there a way to change the color of card based on conditional formatting? Current apply to rules only work in the spreadsheet view.
-
Conditional Formatting if Checkbox is Checked
Hello everyone, I created a checkbox column with 3 cells set to toggle on and off conditional formatting rules. My idea is to paint certain cells if certain conditions are met AND one of the 3 cells is checked. I'm doing this mainly for aesthetic purposes as I don't want to have my sheet multicolored all of the time. Using…
-
INDEX, MATCH, AND formula
I am trying to create an Index / Match cross-sheet formula if two cross-sheet criteria are met. Sheet One displays the Sales Reps for New and Modified Items: I want to display the Item Rep for NEW item types. The formula entered on Sheet Two is: =IF(AND(MATCH(Item1, {SHEET ONE_ITEM}, 0), MATCH("NEW", {SHEET ONE_ITEM…
-
Setting Up Automated Transfers between Sheets
Hi all, I'm trying to sort out if it's possible to have information automatically transferred from one sheet to another. Essentially, I'm hoping to create an automated archive that absorbs all information in our primary sheet once an item has been fully addressed. I haven't come across anything in the training videos that…