Formulas and Functions

Discussion List

• Formula for avg of 1 column to a specific issue in another column

  In Formulas and Functions

  Sheet 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

  DannyApa

  05/20/22

  Unanswered

  9 0

  Question 9 views 0 comments 0 points Started by DannyApa 05/20/22 Formulas and Functions
• How am I able to exclude weekends in a formula to return a number and not a date?

  In Formulas and Functions

  Hello, 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…

  West Coast Alli

  05/20/22

  Answered - Pending Review

  9 1

  Answered - Pending Review 9 views 1 comment 0 points Most recent by Mike TV 05/20/22Formulas and Functions
• Nested If Statement Not Working

  In Formulas and Functions

  I 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 …

  John Johnson

  05/20/22

  Answered - Pending Review

  9 2

  Answered - Pending Review 9 views 2 comments 0 points Most recent by John Johnson 05/20/22Formulas and Functions
• Using COUNTIF on a multi-select column.

  In Formulas and Functions

  I 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.

  FernandoO

  05/20/22

  Answered - Pending Review

  11 2

  Answered - Pending Review 11 views 2 comments 0 points Most recent by FernandoO 05/20/22Formulas and Functions
• Nesting OR Function in COUNTIF

  In Formulas and Functions

  Hi 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!

  Bryan Letourneau

  05/20/22

  Answered - Pending Review

  11 2

  Answered - Pending Review 11 views 2 comments 0 points Most recent by Bryan Letourneau 05/20/22Formulas and Functions
• Count IF one of many values appears

  In Formulas and Functions

  Hi 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…

  Emily McNeeley

  05/20/22

  Accepted

  11 2

  Answered ✓ 11 views 2 comments 0 points Most recent by Emily McNeeley 05/20/22Formulas and Functions
• Creating a graph in Dashboard

  In Formulas and Functions

  Please 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…

  1996mustang

  05/20/22

  Answered - Pending Review

  17 2

  Answered - Pending Review 17 views 2 comments 0 points Most recent by 1996mustang 05/20/22Formulas and Functions
• #no Match Error using VLOOKUP

  In Formulas and Functions

  Hello - 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…

  Bria Berger

  05/20/22

  Accepted

  15 2

  Answered ✓ 15 views 2 comments 0 points Most recent by Bria Berger 05/20/22Formulas and Functions
• Counting the number of Checked Boxes

  In Formulas and Functions

  I 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

  1996mustang

  05/20/22

  Accepted

  11 2

  Answered ✓ 11 views 2 comments 0 points Most recent by Dan W 05/20/22Formulas and Functions
• How to find the Max Valor using INDEX and MATCH?

  In Formulas and Functions

  Rodolfo Garcia

  05/21/22

  Answered - Pending Review

  16 13

  Answered - Pending Review 16 views 13 comments 0 points Most recent by Rodolfo Garcia 05/21/22Formulas and Functions