-
Index Collect that excludes previous values in returning sheet
Hello- I am attempting to create an architecture where employees are auto-populated based on role. I have a sheet with the entire orgs employee list that contains names, employee numbers, and titles The working sheet is attempting to pull in all people of each job title. Each row is a job title (same title with multiple…
-
Need help with combining a formula that has less than, greater than date
I have a formula on row 8 that works with a date that is greater than 3/6/23 (Visit Date) based on criteria from 3 columns and outputs the response in the Overall Status column. This formula uses data from the 2nd, 3rd and 4th columns: 2nd column = Prob List & Notes Status - (has 2 drop down selections) 3rd column =…
-
How to write an "IF" formula involving a checkbox and drop down.
I'm trying to write a formula stating if the "Done" column is checked, then "Status" is complete, but keep getting #unparseable errors. I'm trying to avoid having to click "Done" and also change the status manually to complete. I'm incredibly novice with formulas and would greatly appreciate an assist!
-
COUNTIFS/CONTAINS - Identifying Placeholders
Hello! I am working on getting metrics to identify how many upcoming tasks (next 30 days, etc) have placeholders (from Resource Management) assigned to them rather than a specific contact. There doesn't seem to be a way to identify a placeholder from a contact so I have been attempting to use COUNTIF(CONTAINS.. function…
-
Is it possible to change the formula in one cell of a formulated column?
-
Duration Formula Help
Hello, I am trying to create two duration formulas. One is the duration is between request date and manager approval date and the other is the duration between manager approval date to admin approval date. All three of the date columns are the date column type. The date columns are filled in automatically by Workflows. I…
-
IF with OR
I want to add to my formula for Past Due tasks: =COUNTIFS([% Complete]:[% Complete], <1, Status:Status, <="Complete", Health:Health, <>"", Finish:Finish, <TODAY()) Status can be "Complete" or "Pending" How do I revise my formula? Thank you.
-
Need help creating formula! =SUM(CHILDREN([Time off Personal]@row<'x'))
Trying to create a formula that counts number of days off in children under parent row. Any advice???
-
COUNTIF blank (Date column)
I'm trying to count rows that do not have a date value added in a date column. The right answer is 5, but when I use the following formula, I'm getting 177: =COUNTIF({Approval Date},"") I've also tried the following with the same results: =COUNTIF({Approval Date},ISBLANK(@cell)) Any clues?
-
Index Collect/match formulas / automatically update
Hi everyone, I'd like to have a formulas which reports what we call "Cost Center" from one/multiple sheet into a Year Planning sheet. I need the formula to give me the "Cost Center" if a cell is matching the name of the collapse one (category) above it. Source sheet (Master Sheet NL) : Year Planning sheet : My formula :…
