-
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.
-
CountIF with Criteria including date range
Hello, I'm currently trying to create a countifs formula to count the number of "issue type"(column) "story" where it meets certain criteria including falling within the next 30 days. My base formula works here: =COUNTIFS([Issue Type]:[Issue Type], "Story", Labels:Labels, "Groomed", Status:Status, "To Do") However, when I…
-
SUMIFS/COUNTIFS Function: Total values but filtering out particular Status' AND Dates (Years)
Hi All, Firstly, I'll be honest and say I'm unsure whether this is a COUNTIFS or SUMIFS function but leaning towards the SUMIFS function based on my understanding of it. I'm trying to run a report to show the numner of (Column: Status) Closed Won and Closed Lost opportunities and the (Column name: Value) total value of…
-
Managing Testing with Automation Waterfall Notification and Showing Status with RYGB Balls
I have spent some time looking for solutions to my specific need but have been unsuccessful to find anything that fits right, although there were lots of good suggestions that I tried (and couldn't make it work). We are migrating servers from one location to another and we have multiple IT groups that need to test the…
-
If Start & Finish date lies in the current year then reflect the value in column "X", row "Y"
See diagramed questions in: RED: IF Start & Finish date lies in the current year then reflect the value in column "X", row "Y". GREEN: When % complete value turns 100% then reflect the value in column "X", row "Y". PURPLE: Conversely IF Start & Finish date lies in the next year then reflect the value in column "X", row…
