Formulas and Functions
Archives for May 2022
Discussion List
-
Formula for avg of 1 column to a specific issue in another columnIn Formulas and FunctionsSheet summary looking to get an average time to repair for specific issues that come in. Currently I have a formula that show AVG for every issue Trying to get a formula to show this average to add to a dashboard view
-
How am I able to exclude weekends in a formula to return a number and not a date?In Formulas and FunctionsHello, I need to write a formula that calculates how many days it takes to complete a PO from the time it is received., but I want it to exclude weekends. I have seen the WORKDAY function, but I am not trying to return a date. I am tryin…
-
Nested If Statement Not WorkingIn Formulas and FunctionsI am trying to write a nested IF statement to automate the RYG status balls in a status column. It will not work, it always say they are red. What am I doing wrong? Logic Needed: If less than 70% complete, "Red" status ball If …Answered - Pending Review 9 views 2 comments 0 points Most recent by John Johnson Formulas and Functions
-
Using COUNTIF on a multi-select column.In Formulas and FunctionsI am trying to use COUNTIF on a multiselect column when two or more items are selected. very easy when only one item is selected but not working with multiple items selected.Answered - Pending Review 11 views 2 comments 0 points Most recent by FernandoO Formulas and Functions
-
Nesting OR Function in COUNTIFIn Formulas and FunctionsHi Community, I'm running into an error while nesting my OR function and I can't seem to identify a solution and would appreciate some help! Please see below: Thanks!Answered - Pending Review 11 views 2 comments 0 points Most recent by Bryan Letourneau Formulas and Functions
-
Count IF one of many values appearsIn Formulas and FunctionsHi there, I always get hung up on the HAS formula. I am trying to pull data for a dashboard in a separate dashboard data sheet so I am referencing another sheet, let's call it "Supplier Data" and I want to count the number of ti…
-
Creating a graph in DashboardIn Formulas and FunctionsPlease see the attached snip-it. I am counting the checked boxes in the columns and I want to display this in a graph format in a Dashboard. When I add a graph widget to the dashboard using the checkbox count totals, I get a message tha…Answered - Pending Review 17 views 2 comments 0 points Most recent by 1996mustang Formulas and Functions
-
#no Match Error using VLOOKUPIn Formulas and FunctionsHello - What I'm trying to do is return the name of the team member that owns the workstream onto a different sheet. I went with the vlookup formula and keep getting a no match error. Details and screenshots below. I want the formula to lo…
-
Counting the number of Checked BoxesIn Formulas and FunctionsI have a column name Phase I and I want to count all the checked boxes from row 1 through row 20. I am using the following formula: =COUNTIFS([Phase I]1:[Phase I]20, =1) What I get is #Boolean Expected? Any Suggestions? Regards
-
Answered - Pending Review 16 views 13 comments 0 points Most recent by Rodolfo Garcia Formulas and Functions