Mike Norman
Mike Norman
Reactions
Discussions
- I am trying to tally up a total of percentages by Resource name, and and the Level of Effort % that was assigned to their work. When I do a countif statement it will count the total projects with a Le…
- Hello all, I am having an issue trying to use what should be 'basic' conditional formatting for percentages in a column in my sheet, where there are no colors being displayed as intended. Green = 55% …
- I need your help to show status as Yes, No, Hold using this criteria: No - 90% + Hold - 51% - 89% Yes 0% - 50% This is my current formula, where the 'Yes' and 'No' icons show up as intended, but those…
- Hello, I am attempting to create recurring notifications for projects. I am running into issues due to the different reporting requirements (some are monthly, some quarterly) for when updates are requ…
- Hello, I am attempting to JOIN two date columns, and keep getting a #CIRCULAR REFERENCE error. My formula: =JOIN([QAM VOD Shutdown Date]@row:[Ending Date]@row, " - ") Can anyone make a suggestion why …
- I am trying to pull a metric from my main sheet, where the columns are named by month (Apr Calls, May Calls, Jun Calls, Jul Calls, etc.). How can I pull the current month's result cleanly without havi…
- Hello everyone, I am attempting to create a formula that references another sheet with multiple IF components, and I am stumbling with the date range. I currently have: =COUNTIFS({OPUS Range 1}, "West…
- Hello, I am trying to automate my status column that is driven by dates. Date columns: Deployment Start, Deployment End, Planning Start, Planning End Statuses: Planning (this is default) status; Execu…
- Hello, I am running into 'Incorrect Argument' error when trying to count cells that have a blank date for Training Start column from another sheet. My formula is: =COUNTIF(ISBLANK({NED_Project_Master …
- I am attempting to use a nested IF statement that assigns a number based on a dropdown selection. Example: User chooses "Medium" in the Impact column, and I'd like to assign a value to that selection …
