Formulas and Functions
Archives for June 2021
Discussion List
-
COUNTIF and...In Formulas and Functions=COUNTIF({Template -Tasks Range 1 - Due Date}, <=TODAY(7) I have this working, however how do I add Only if the Status column from origin sheet is not complete? I've tried variations around this... =COUNTIF({Template -Tasks Range 1 - D…
-
Please help: Index matching formula not populated new lines of dataIn Formulas and FunctionsHi, I have an index matching formula from multiple source sheets based on a condition in th destination sheet. It seems to work fine if I change the condition on existing data but it does not populate on new lines of data. I have set the …
-
Using IF and OR function in a formulaIn Formulas and FunctionsI am so close to getting this, but each time I tweak it, I get an UNPARSEABLE message. I am trying to get the Column Titled: Duration (In Hrs) to zero out if EITHER the Not Applicable or Optional rows are checked. The below formula is only…
-
Help NeededIn Formulas and FunctionsHello, All. I need to create a formula where I am summing particular values in the same column wherever that value appears. For example, if 1 appears 5 times in the column, I wish the formula to return 5. However, I also wish this formula …Answered - Pending Review 12 views 4 comments 0 points Most recent by Gretchen Hansen Formulas and Functions
-
Flagging a row based on it being the original entryIn Formulas and FunctionsI have a sheet that is populated through a form. My employees look at many files a day and some are duplicates from the same day, previous days, weeks, or months. I want only the original file to count in my tally, so I am trying to build …
-
Formula to Count If NOT one ofIn Formulas and FunctionsHello, I have a formula that is counting based on specific role, but now I want to adjust this formula in a new sheet to only count if not in those specific roles. How can I use the OR function with a not or doesn't equal? Here is the curr…
-
How to combine a COUNTIF and a COUNTIFS formulaIn Formulas and FunctionsI need to get a number of how many contracts were approved, not approved, pending in April, May, June, etc. of the same year. The following formulas work separately to give me: The count of contracts approved =COUNTIF(AND([Status]:[Sta…
-
Countif to create sequence numberIn Formulas and FunctionsHi All, I hopoing to use this formula as a column formula (to auto fill as rows are added), but if using absolute references it can not be used as a column formula. Does anyone have any work arounds? =COUNTIF($[TW Job number]$1:[TW Job nu…Answered - Pending Review 40 views 4 comments 0 points Most recent by Loucas Tsiartas Formulas and Functions
-
Looking for a formula that can tell me the amount of work completed per employeeIn Formulas and FunctionsHi! I'm attempted to find a formula that can tell me the number of tasks completed per a specific employee or "navigator." I've attached screenshots of what I've tried, and I'm struggling to understand why this won't work. The f…Answered - Pending Review 12 views 1 comment 0 points Most recent by Bassam Khalil Formulas and Functions
-
I need a formula that looks at two columns and puts the data into the column that is not blank.In Formulas and FunctionsSo it will need to look at two columns and put in what is not blank.Answered - Pending Review 13 views 1 comment 0 points Most recent by Toufong Vang Formulas and Functions
