-
Dashboard - Charting how many checked out of total boxes
I have a sheet that has checkboxes. I would like to be able to make a chart in the dashboard that shows percentage of how many checked out of total. I have a count for the checked boxes, but no total to reference. How would I go about this?
-
%Complete to be automated
I am trying to work on my sheet to get the % Completed to be automated. How can I go about doing this?
-
Creating a Task Tracker for Multiple Leaders
I manage a large group of leaders and locations who all are completing similar tasks throughout the month and I am looking to track progress without going back and forth via email. I have created a task list for each location as the parent and each specific task as sub-tasks and then assigned them to each leader. When I…
-
cross-sheet duplicate search
Thanks in advance for reading this :) I have multiple inventory sheets, each has a column with a formula to flag duplicates within a specific column: =IF(ISBLANK([Serial Number]1), "blank", IF(COUNTIF([Serial Number]:[Serial Number], [Serial Number]1) > 1, "yes", "no")) Form there, I apply some simple conditional…
-
Highlight Colours
Hello, I have an 'Alerts & Actions' when a row is added to email out many cells. When this email arrives in my staffs inbox the cells are bright yellow. Is there a way to change the colour? - I would ideally like a less bright colour? Any help would be wonderful. Thanks Matt
-
Index Match with some data returning as Invalid Data Type
I'm using an Index match to pull a certain number. In this column I will get a successful return of a few number then the Error then more correct numbers. Thing is, they are all pulling from the same data set (from an API), and using the same parameters and search values. Why am I getting the Invalid Data Type error?
-
Hyperlink in a Request Update form
I am looking to see how I can insert a Hyperlink into a Request Update Notification.
-
Hyperlink
Is there a way to include a hyperlink in an update request when they open the update form button?
-
Copying multiple indented rows
Is there a way of copy & pasting in multiple indented rows without having to do individually?
-
Report Sheet Scope Limit
I am receiving a notice that our reports have 302 sheets in scope and that it is recommended that the scope be reduced to 250 for better performance. Does anyone have insight into what performance issues having too many sheets create, and any workarounds? Is there the ability to improve whatever is causing that limit? We…