-
Join Collect with text
Join Collect is a new one for me and I am struggling... I am wanting to JOIN COLLECT with results only with BFF PM, listing the contact name/card Master sheet: Current formula: =JOIN(COLLECT({Area Contact Range 2}, {Market Area}, [Market Area]@row, {Title}, "BFF PM"), " , ") Reference:
-
Track Birthdays and Anniversaries coming up
I am trying to set up a dashboard to allow me to see upcoming Birthdays and Anniversaries, with them being sorted to earliest upcoming being at the top of the list. I tried, what I thought would have been to do a min collect, without luck. Then I thought maybe someone had a better idea as to how to make the happen.
-
sumifs
Hello, I am trying to sum project hours by project per month and seem to be missing something. I am trying to use: =SUMIFS(Hours:Hours, Project:Project, "HGI Condado", Month:Month, "January") But this formula yields "invalid data type". Not sure what I did wrong. nay help would be great!
-
Formula to Collate Entries based on Criteria
Hi I'm looking for a concatenate type formula that will collate a number of line item updates based on their project ID. I have a sheet that contains multiple tasks for a project, each having an update. I want to collate all the task updates, based on Project ID, into a rolled up view to give one overall update of the…
-
Breaking up a long form
Hi all! Ran into some snag with forms... I have 40 items in 4 categories to rate. Putting all 40 items on a single form is not the ideal user experience (but if nothing else works, that's how the cookie will crumble). So, I thought I would break the forms into four forms. One calling the other after each submission. I can…
-
How to properly add a task to "schedule a meeting"?
Here's an example with some sample dates: Task #4- I want to hold a project kickoff on 3/31 Task #3- In order to do so, I need to schedule the meeting by 3/24 and then send off the kickoff deck (to give all attendees ample time to accept) Task #2- In order to schedule this meeting, I need to send out an email to the…
-
RYGB Based on Status and End Date
I know this question has been asked before (and I also Googled it), but I'm having a difficult time trying to create the RYGB balls. Can someone help me? I put together the matrix (see below):
-
How to count a value in a column based on the values of other two columns?
I'd like to know if there is a way I can count the status of the Tasks for an Area based if the Discipline and Quarter is a given value. For example, I want to count how many "Completed" "Ongoing - On time", "Ongoing - Issue", "Active" and "Planned" there is in case of the other values are "Herb" and "23Q1" So in this case…
-
COUNTIF or COUNTIFS to sum blank fields
I have many columns and I need to sum the number of blanks within a row. There are a few columns interspersed that are hidden helper columns that should not be included in the count. I have not been able to get a formula to work when trying to account (and not count) for the helper columns (in this example column 11 and…
-
Expense Sum Formula
I need to be able to calculate expenses per event and per expense type. I feel silly asking as I should know this but my brain just isn't calculating today. I have tried many variations of the following and it's still Unparsable. I've also tried adding @cell. What am I missing? =SUMIF([Event Title]:[Event Title], "MS CI…