-
Join Collect formula for multiple values
Is it possible to use a Join / Collect formula, which references a multi-select dropdown list in one sheet to find and query an array of values? In Sheet 1, I'm querying a set of values however I can't seem to pull anything forward when multiple values are listed in the Client Name column. I'm trying to pull forward every…
-
Automated Copying of Rows to Another Sheet
Hi everyone I love the function to automatically copy rows to another sheet but I would like to ONLY copy specific columns. Is this possible? Thanks in advance. Tracey
-
IF And Statement with Dates
Hello! I'm getting an invalid data type when I use the formula below. I used a replicate of this formula for other months of the year where I update the month portion to the relevant month and have had no problem. Any ideas about what's wrong with May? =IF(AND([Today's Date]@row >= DATE(2023, 5, 1), [Today's Date]@row <=…
-
Index/Collect - #incorrect argument set
Hi Can anyone please tell me what is wrong with my syntax? I have done index/collect before and the syntax is the same. The dates are "text" which shouldn't matter. I also tried numbers in place of dates and still get the same. I am baffled....
-
Copy the contents of a cell to another sheet only if a column in the same row is set to "Yes"
Hello, I am trying to automate copying of customer names from one sheet to another based on a second Yes/No column. Only customers with "Yes" in the secondary column will be copied to the new sheet. The secondary sheet will contain additional columns, so the Automation function will not facilitate the copy in the way I…
-
Calculate amount of hours between dates and times
Hello, Can anyone help me calculate the amount of hours and minutes between dates and times? I have tried numerous formulas but none are working for me. Is there any particular format the time column needs to be? Appreciate anyone's help with this, thank you. Leah
-
"Row Summary" Pop-up to add longer notes
I am looking for a solution similar to "Sheet Summary" but attributed to an individual row. It would be great to have a spot where I could enter a long, free flowing, list of notes about the account. It doesn't fit nicely in an individual cell. I've thought of inserting a link to a google doc or some outside resource, but…
-
IF Status / % Complete / Progress
I have a Project Tracking list sheet that has a Drop-down Status column including At Risk, Pending, In Progress, and Complete; we use card view for this. % Complete column that is a text/number field, and Progress symbol column (Empty, Quarter, Half, Three Quarter & Full). Is there a formula that could be used in the %…
-
Create Contact using INDEX/MATCH
I need to have a contact list populate based on the name of the PM entered into the PM column. Just so you are aware, I attempted, to change the PM column from a dropdown to a contact list, and the 22 workflows I had created all broke. So on my PM list, there is a column named PM, which is just text (this is the primary…
-
Count Index Match Formula
I want a formula to retrieve a count of how many nurses have a BSN degree by unit from a spreadsheet. I have a sheet with the list of units as the primary column and degrees listed for the other columns. The formula needs to look at the main data sheet for this number. Is this possible?