I have an existing sheet which contains a schedule of annually recurring tasks. I saved a copy to create the new year's sheet and now need to update the dates. Is there an automated way to do this?
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?
I am trying to work on my sheet to get the % Completed to be automated. How can I go about doing this?
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…
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…
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
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?
I am looking to see how I can insert a Hyperlink into a Request Update Notification.
Is there a way to include a hyperlink in an update request when they open the update form button?
Is there a way of copy & pasting in multiple indented rows without having to do individually?