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 T…
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…
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 s…
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…
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 …
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…
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 trie…
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 match…
