-
Hiding rows
I would like to be able to hide rows can only find option of hiding columns. It would be especially helpful if hiding rows option could be added to conditional formatting.
-
Alternating Row Colors
Hello, I am trying to format my entire sheet with colored rows that alternate. The Excel formula that perfomrms this is : =MOD(ROW(),2)=0 This would be an awesome feature but I can't seem to fiund anywhere in the UI. Thanks for your help.
-
Sheet Roll-Up
I'm curious if there is a way to have a "higher level" sheet that pulls from other sheets. That way, each individual on our team can have their own projects with greater detail and our supervisor can see a higher level view of everything being worked on.
-
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.
