-
Dropdown Maintence.
Hello, trying to figure out what the best solution is. We have a dropdown with all the builders that we work with. It's constantly needing to be added to and sorted alphabetically. Right now we have a sheet that we add new accounts to and once I get an alert I sort them alphabetically, export, copy and past into the drop…
-
Sheet summary formula
I have several status for work in progress. They are very detailed and granular (not started, writing in progress, review 1, revisions 1, review 2, revisions 2, editorial, final review, ready for client). I would like to create a sheet summary that counts several of these statuses together (example: grouping writing in…
-
Notification at multiples minus a number
Hello, I have a spreadsheet where each row counts hours, then a column keeps a running total of all hours. I would like to be notified at certain intervals as every 150 hours I need to do a task however I need some prep time so I would like to be notified 20 hours before 150. So when my column value reaches 150, 300, 450,…
-
Formula to calculate the last day of the year based on another date column
I have a sheet that tracks Agreement Execution Dates, and I would like my Agreement Expiration Date column to record the last day of the year of execution (so if executed 5/1/20, expiration would be 12/31/20). How would I write this?
-
COUNTIF with dates pulled from cells?
Hello! I'm trying to run a count of the number of entries on a sheet, where the "needs analysis assigned date" is greater than 5 days prior to the "date requestor contacted" date for that same row of data. Example: Row 1: Needs analysis assigned date: 11/1/2022 Date Requestor contacted: 11/2/2022 The date difference only…
-
Create Leaderboard with growing, non-static list
I would like to create a leaderboard report using a list of names that is non-static. Meaning I have a list of 20 names today and I could create a leaderboard from that data, but the source sheet is going to have names added to it over time and I would like to the leaderboard to reflect that growth. So when 21st, 22nd, etc…
-
How do I do a min/max output based upon a specific criteria?
So I think I've come close to this in the area of indexing, matching, etc., but I can't quite get the formula to work the correct way. I have a sheet setup to where it calculates the average number of days that specific jobs have been open and working within several different groups in my organization. Each organization…
-
Formula adding previous days
My goal is to have a summary sheet that shows by day how many tasks each worker completed and how many they did not. The intake sheet is set up for them to enter the date when they input data so if they are on vacation or just don't do it, no date is present. This is my summary sheet to add up done and undone checkboxes…
-
Multiple Contacts and effort total
Hello, I am tracking tasks with an Assigned To column and Effort column. My original sheet required repeating the same task and assigning to each individual who would perform that task, and then using the Sum(Children()) to get the total effort for all child tasks. I would like to allow the Assigned To column to use…
-
Duplicating sheets deleting certain columns and team distribution via viewer mode
All, Thank you for your time. I am trying to accomplish a few things simultaneously: I have a master account sheet that I want to send out to the rest of my team but I want to do it in the following way: Send them a duplicate sheet with certain financial columns omitted As I update the master sheet, the sheet that is sent…
