-
Looking to Countif a person's name is contained in a column that allows for multiple contacts.
=COUNTIFS({OTP Goals Project Lead}, CONTAINS(Contact@row)) the OTP Goals Project Lead is the sheet that has the column that is a contact list that allows for multiple contacts. If a person's name is contained in that column and it matches the name in the column on the metrics sheet called Contact - then I want it to count…
-
Using IF/AND with two ranges of data.
I have been working on the following problem for a couple of days, but I have not been able to get anything even remotely correct to work as desired. I can only get anything to execute if I tie the two lookup cells to row #. =IF(AND(Adresses@row = Streets1, Include1 = "Yes"), "Yes","No") That is obvious not what I want!…
-
Dynamic dropdowns - Waterfall request
The Contact List, Dropdown (Single Select), and Dropdown (Multi Select), are useful tools to control data entry. The problem is they require a lot of maintenance. Through Bridges, we have a sheet that is populated with information from our ADP. It contains all of our employees. Using a Contact List column and selecting the…
-
Dynamically Scheduling Another Workflow
This is my first time trying to have one workflow dynamically schedule another and I must be doing something wrong. What I want to happen: On our main customer workflow, it is triggered by the specialist changing the Stage status. When they change to a specific stage, an email is triggered to the customer via our SendGrid…
-
Missing Auto Update Component
Hi - I am receiving the following message on startup with the Desktop app Any solutions would be much appreciated
-
Auto Generated Number formula based on value in another column
I need help with a formula: Need auto-generated number based on: If value in "type" column is "Type1", auto-generate number in column "number" , otherwise, leave blank Cannot use Auto-Generate number column because of criteria Can make column formula to ensure auto-generated number is in new and existing rows
-
Nested IF/AND
I have two formulas that work independently as they should, but I need to combine them into one and count NETDAYS, if a certain department, and count NETWORKDAYS for all other departments. I was able to combine without error, but it doesn't calculate properly, it will work for one but not the other. Formula 1 - is the one…
-
File Attachment to Multiple Rows in a Sheet
When creating document mapping sheets for Projects, or Functional and Non-Functional Requirements response sheets for RFPs, it would be greatly helpful to be able to attach a single file to Multiple Rows in a Sheet. Now, we can only upload a file to a single row, but if that one file applies to multiple rows, it would have…
-
INDEX/MATCH formula assistance needed
Hello. I'm using the following formula to match resources with their resource manager (=INDEX({Resource Manager2}, MATCH([Assigned To]@row, {Resource2}, 0), 1) ) and it works great for a 1:1 scenario. However, I have a many to one, or many to many scenario and I need help modifying this formula to accommodate both of them.…
-
Better lookup formula
Implement xlookup equivalent. Current "vlookup" sometimes requires complete sheet rearrangement to work, and can preclude a reverse lookup from working, where xlookup can lookup anything in the sheet from a key field. Excel did this years ago and there's really no reason to ever use vlookup there on a new formula again.