-
Giving users access to only their assignments on a sheet/report
Hello, I have a commission sheet set up to payout multiple agents and I only want the user to be able to access and see their payouts. Is there any way to share a sheet where the logged in user (free user) can only see what was assigned to them? I know I can do this on a report but the sheet still needs to be shared in…
-
Help with adjusting a formula
So the formula below is used to determine the colors of the dots. However, I need it modified so that for Blue Dots, they will be Blue based on the current condition already there, or if the start date or finish date are empty. I was unable to figure this out on my own so thought I would post it here =IF(OR(Status@row =…
-
Counting (and Averaging)within Columns
How do I create a Counting formula to count how many times an Owner Email created a Title on Create Date? Is it possible for me to add the average Score to that count? Example: 3 = anisiac (owner email) created Workforce Management Opp (title) on 1/13/2020 (create date) 91 = Avg Score
-
Need help creating a formula
I do a project status report for my team. We currently have status options like: "Not Started" , "Active", "Active + Concerns" and "Complete. I recently made another status option: "Cancelled - Covid19". I make a dashboard for my supervisor that highlight the number of projects that aren't complete due in the next 7 days.…
-
RYGB BAlls with B = empty cell
I have a basic formula I can't get to return a B ball when there is an empty cell. =IF(Count@row = 0, "Green", IF(Count@row > 0, "Red", IF(Count@row = "", "Blue")))
-
Form error checking - adding up to 100%
I was asked to create a survey where various locations would be asked the total parking area and then percentages of the area dedicated to particular usage (i.e. tractor trailer parking, truck parking, customer, etc.) I can set up the field for this easily enough but I am running into an issue of making sure the numbers…
-
Calculate work days in formula, excluding weekends
I have three columns, Projected Hours to complete a task, Start Date and Finish Date. I have a Vlookup that populates the projected hours cell based on a product group identifier. Someone then enters a start date and i have a formula in the finish date cell that calculates the end date based on the projected hours. I would…
-
Countifs multiple fields and values
I"m trying count projects that are in IT Org (column) and are in project states (column) of New, Awaiting Endorsement, Project Analysis, Financial Review, ITSC Approval. COUNTIFS{IT Org Sheet Reference}, "IT", [{Project State Sheet Reference}, "New"...??How do I do counts of all other project states?
-
Would it be possible to add multiple request approvals in one approval request?
This would greatly reduce the number of automation work flows for a given sheet. I want to do this (instead on multiple work flows) so I can get and see individual responses in separate columns.
-
Can anyone help with a formula to count distinct entries that are not "N/A"?
So far I have been able to count distinct but have not been successful in excluding the "N/A" value. Any help is greatly appreciated.