-
How to return email addresses for multiple contacts in a cell?
I have a column name Project Sponsor/ Owner with multiple contacts in the cell. In another column I have Project Sponsor Contact, which returns the email address for the sponsor. I created a VLOOKUP formula and it only found the email for one contact in the cell, but not emails for multiple contacts. What logic do I use to…
-
Form Submission Email - Data Not Populating
At my company, we use a form to collect data from other groups. When the form is submitted we receive an email notification, prompting us to complete our end of the assignment. However, when certain questions are answered and free text boxes completed (via logic tool), the free text boxes aren't appearing on the email…
-
Date Formula
I have two quick questions; I need a formular to express the following: End date of column A = Start date for column B ( I tried setting the columns equal to each other but get an error) Second formula Column C = Column B +10 ( I tried Date1 +10 but get an error)
-
AVG a column, Collect the data for a specific employee, yet needing to exclude zero
Here is my formula: =AVG(COLLECT({Bio Validation Completion Time}, {Bio Validation Schedule Scientist}, [Principle Investigatorss]@row)) Which is working; however, i want to exclude zero's. I tried this: =AVG(COLLECT({Bio Validation Completion Time}, {Bio Validation Schedule Scientist}, [Principle Investigatorss]@row,…
-
Sum of hours from various cells and subsequent calc of FTE based on certain criteria
Hello, I would like to ask for help. I've got a sheet that can automatically calculate the FTEs of people assigned to projects but I need a little tweaking. There is a current layout: Currently, the FTEs are calculated based on what region is the global lead and that takes into account the "Lead MM - MDR Oversight Hours"…
-
Formula in excluding weekends when adding number of dates in a formula cell.
Hi, I need help what is the formula for me to be able to create automatically a due date in a cell, based on the automatically created date column but I don't want to include weekends in the count. I wanted to set an automatic due date based on the priority selected in a row. For example: Date created is October…
-
How to have symbol ticked if the variance of baseline is more than -5 days behind. can this be done?
-
Help with Formula to Return Value of Another Row when Certain Criteria are Met
I need help with a formula that I have no idea how to do. The sheet columns and an example scenario are below. The column highlighted in yellow is what I'm trying to populate/where the formula will be, showing the values I would expect for each row. Basically, I want to populate the Reposted Date for a row with the Job…
-
Countifs with reference to another sheet
Hello, I am trying to use the following formula: =COUNTIFS({Facilities Scorecard - All Lots Region}, "1", [{Facilities Scorecard - Traffic Count Standard}, "Y,"]) and =COUNTIFS({Facilities Scorecard - All Lots Region}, "1", [{Facilities Scorecard - Traffic Count Standard}, "Y,") but it keeps coming up as "UNPARESEABLE."…
-
Formula question when counting 2 values in a restricted drop down values only column
Hi, hope you can help me. I have this formula =COUNTIFS({Clients Status Active}, "Active", {Client Grouping}, "Remote Access + Shared Folder – Not Validated") and i want to add 1 more criteria {Primary ID}, "Y", "Generic") I want it to count both the "Y and Generic" in the primary ID column. I keep getting a incorrect…