-
Converting an Authorization Matrix into an Approval Sequence
This is tough to explain. This first screenshot is a list of people who can authorize purchases. The 2nd column denotes their dollar value limit for any single purchase authorization. "Department" denotes what department in which they're allowed to make those authorizations. I'm trying to convert this list to a second…
-
I am trying to calculate the average percentage of a range of values but only for certain dates
Hi! I am trying to calculate the average percentage of a range of values but want to include values that are within a specified date range- i.e from 1/1 to 3/31 or before x date or after x date based on information in a specified date column. In this case I have a column for Training Date and a column for Training…
-
How do I return a cell value based on a date in another column
I'm trying to automate a process that involves a few sheets and a form. I'm creating a fleet management process where drivers will complete a daily vehicle check out form, which will capture any issues the vehicle may have, and also the current mileage. The form is built on a master sheet which then feeds an individual…
-
Join Collect Header?
I am trying to figure out how to consolidate a group of companies that use a specific application. Each application has its own row. Each company has its own column and a "Y" is added to the field where they intersect to indicate that the application is used by the company. I would like to combine a list of all of the…
-
Lock cells that contain formulas
Hello, Is there a way to lock cells that contain formulas? I ask because although there is a way to lock columns/rows, I've found that (all parties w/Admin privileges) you can accidentally click on a cell and change the formula. Cheers. 😀
-
IF for dates and text
I am trying to turn a symbol a certain color based on the following If the status column is complete, turn it blue and ignore all else. If the status column is anything but complete use the following =IF(TODAY() - [End Date]@row > 0, "Red", IF(TODAY() - [End Date]@row > -3, "Yellow", "Green")) The above works for…
-
Formula if multiple choices
I have a Countifs formula that I can get to work if a single item is selected from the dropdown but not if both options are selected. I want to count: 1) Who's affected is Internal (works): =COUNTIFS({ProjectStatus}, "Open", {WhoAffected}, "Internal", {Live}, "Live Input") 2) Who's affected is External (works):…
-
1 contact list for all sheets
Hello, I have several sheets that use the same client contact list. Right now, everytime we add a new client, I have to update the list in about a dozen sheets and counting. Is there a way to have one contact sheet and all sheets can pull the contact from that sheet instead of me updating a contact list in every sheet?…
-
Tally of scorecards
We have 23 scorecards with sample data below that we want to roll into a combined scorecard. We started avg each cell for each person and ran into the reference link max for one sheet. When we tried to create a report to tally the average score but the right fields are not showing. Any thoughts would be helpful.
-
INDEX/MATCH for Mirroring Status Column in Another Sheet
Hello! This may not be right formula, but if a user shared a sheet with me which contains a project codes column and a status column (complete/incomplete), and I use the same project codes, can I do a formula which pulls in their status into my sheet? Something like - If (External Referenced Sheet / Column A) matches…
