-
Question on merging single contact columns into one multi contact column
Hello, I have a contact column containing one person, and another contact column containing another person. I have another contact column that is set to take multiple contacts. What formula can I use to get both contacts into the one multi contact column? Thanks Steve.
-
Using Collect to Get Average from Previous Year Data
Hi, I'm trying to get an average using collect where the data was stamped with a date from last year: =IFERROR(AVG(COLLECT({GIWO_Completed_2023 Range 3},{GIWO_Completed_2023 Range 5}, DATE(YEAR(TODAY())-1),{GIWO_Completed_2023 Range 2}, OR(@cell = "New Br4 (Frankfurt)", @cell = "Existing Br4 (Frankfurt)"))), "-")) If you…
-
#INCORRECT ARGUMENT SET error
Good afternoon, I have been getting #INCORRECT ARGUMENT SET error when using this formula: =IF(AND(Category@row = "Demo account"; [Custumised timeframe]@row = "No"); Submission@row + 30; ""; IF(Category@row = "Content contributor"; [Estimated Editing end date]@row; IF(AND(Category@row = "External supplier"; [Custumised…
-
COUNT IF + NOT CONTAIN
I am using the formula below and the NOT CONTAIN is not working. Could anyone help? COUNTIFS({Spreadsheet_1 Range 3}, "John Smith", {Spreadsheet_1 Range 1}, "In Progress", {2023 Spreadsheet_1 Range 2}, NOT(CONTAINS(@cell, Maintenance))
-
IF(OR) formula - add AND qualifier for all
I have an IF(OR) formula that is working exactly the way I want it to. I want it to check a box if one of three column criteria is met, which it is doing correctly, using the below formula: =IF(OR([Column A]@row = "Choice1", [Column B]@row = "Choice2", [Column C]@row = 1)), 1 I want to add a second condition that applies…
-
Max Row Within a Group
Hello, I have sheet that gets a row added every time someone add a response. The example shown is a simplified version. Each response is associated with a Group of combined columns (1 company + 1 ticket) - See column named "Join". Users can add a new response for each Group over and over. Each time they add a row, the…
-
Formula Counting blank values W/ =COUNT(DISTINCT(COLLECT
I'm trying to collect data from other sheet and COUNT with DISTINCT. EXAMPLE 1: =COUNT(DISTINCT(COLLECT({NAM-SERIAL}, {NAM-RTS-FW}, [FW11 2024]76, {NAM-FW-OFF}, <>""))) EXAMPLE 2: =COUNT(DISTINCT(COLLECT({NAM-SERIAL}, {NAM-RTS-FW}, "11", {NAM-FW-OFF}, <>""))) EXAMPLE 3: =COUNT(DISTINCT(COLLECT({NAM-SERIAL}, {NAM-RTS-FW},…
-
How to reference Sheet Summary cell in the text of an automation?
I've been usign columns references in the text of my automations messages a while now. It looks like that. The text is in french but you can see the symbols used. Bonjour {{Fournisseur}} Voici la confirmation de commande pour le projet {{Projet}}. La date de début est le {{Date de début}} La date de fin est le {{Date de…
-
How to get top 5 from a contact column w/repeating contacts and counts?
I have literally spent 20+ hours trying to figure this out by reading similar questions and asking AI. It's not working, I haven't felt this frustrated since taking a coding class in college (probably only last the same amount of time too)....Please help me and break it down to me like you are trying to teach a goldfish. I…
-
How to calculate X hours from the Created Date time stamp
Hi, I am trying to create a formula that will add 5 hours to the Request Start Date (which I am using the created date for) if Priority = critical. =IF([Priority]@row = "Critical", [Request Start Date]@row + (5 / 24), IF([Priority]@row = "High", [Request Start Date]@row + 1, IF([Priority]@row = "Low", [Request Start…