Sign in to join the conversation:
I am using this formula to Sum all values except for the ones assigned to "External"..It still adds these hours. What did I miss?
=SUMIF([Resource Type]:[Resource Type], "<> *External*", Hours:Hours)
Hi Gwen,
Try something like this.
=SUMIF([Resource Type]:[Resource Type], <> "External", Hours:Hours)
Did it work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
It does.....thanks...You too
Excellent!
Happy to help!
Hi all. My team is currently using a sheet to track tasks and hours spent on each task, for each week of the month. There are 4 different types of tasks (Project, Initiative, Ad Hoc, Daily Task), and some of out project managers work on the same project or initiative. I am trying to create a COUNTIF formula to count the…
I have a collection of sheets (10-12) that all have projects in various stages that need a status review/update. This is a temporary process and I need to be able to assign each project to an employee, but these sheets don’t have an assignment column already built in them. Is there a way to set up an assignment system…
Okay, so I have been working this problem for a few days and it's officially making me crazy. Here's the problem statement: I have 3 intake sheets for different business units. Each has an Auto-Number column that has a prefix for the BU. I need to consolidate all of the attachments from those 3 sheets into 1 sheet. So on…
