Formulas and Functions
Archives for August 2018
Discussion List
-
Auto populate from one sheet into blank rows on anotherIn Formulas and FunctionsHi All! I searched for this, but couldn't find an answer. Maybe it doesn't exist! I'm trying to set up a new dashboard for sales reps. In one sheet I will have them fill out all of their activities. I was TRYING to get them to fill ou…
-
Counting total specific drop-down option between 2 datesIn Formulas and FunctionsHello! The sheet that I am working with is used to track agreements my department works with. Two of the data points (among many) that we capture is the agreement type within a drop-down and the signature date. I would like to capture the…
-
countif helpIn Formulas and FunctionsHi all, I'm trying to figure out a way to sum the number of one column if it has the value of another column. The formula I was trying is: =COUNTIF(Scoped:Scoped, Channel22) I want to know how many are scoped in the scoped column if the…
-
Sheet Template : When copying a template, my formula's don't migrate.In Formulas and FunctionsI'm trying to copy a template to use. I have formulas already on the template, however when i put the new numbers in, it doesn't use the formula to add/subtract them. I have to litterly go through and on every sheet I create from either a …Answered - Pending Review 115 views 3 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Help needed counting across sheetsIn Formulas and FunctionsHi all, I am trying to use the count of a symbol across some sheets. I know I can get this information by creating a report but for a more visual presentation, I am looking to get an actual number. I am currently trying something like th…
-
Help needed with an If/And formula referencing another sheetIn Formulas and FunctionsThank you for taking a look at this. I have one sheet where I am trying to show the count for a person on another sheet IF another column has a 1 in it. The 1 represents a checkbox in the ajoining column. For some I have tried looking for…
-
Calculate days since a bubble turned redIn Formulas and FunctionsI have a column that shows red (off track), yellow (at risk), or green (on track) depending on whether a date column (completion) is before or after another date column (goal completion date). What I'd like to show is the amount of days si…
-
Access (visibility and the option to edit) to SOME rows in a sheetIn Formulas and FunctionsHi, First, thanks for members of this forum, you’ve been a great help! I have one main sheet where all (different) legal tasks are listed to help the legal team manage the work load. Only the legal team has access to this sheet. One of …
-
INDEX/MATCH not workingIn Formulas and FunctionsBelow are two screenshots. The first is a screenshot of my target sheet. The other is a screenshot of my reference sheet. On the reference sheet I have a list along the left. In the column to the right is: =TODAY() On the target s…
-
Formula to display Red FlagsIn Formulas and FunctionsI am attempting to have a RED Flag populate in the "Risk" Column for cells where the "Available Space" is less than 10. Kindly when answering, please complete the entire formula from start to end as from research I te…