-
How to use a COUNTIF formula to determine how many times a word appears in a multi-select column?
Hi, I have columns that allow users to "select all that apply" however, I want to be able to summarize/count the number of times each value appears. For Example: Column: Fruit Cell 1: Apples, Pears Bananas Cell 2: Apples, Pears, Oranges Cell 3: Apples, Oranges, Bananas Summary: Apples: 3 Pears: 2 Bananas: 2 Oranges: 2 The…
-
Can I populate multiple lines in a report from one form
I am trying to automate our joint health and safety checklist. I have created my data sheet with 88 columns and created my form. Each question has a drop down with yes, no or N/A. When no is selected a comment box comes up to insert the issue. What I want to do in my report is create one row for each issue that arises…
-
SUMIF Doesn't Work When I Reference Another Sheet
When I use this formula it works =SUMIF([Target Month]:[Target Month], "February", [# of Devices]:[# of Devices]) But when I put it in another sheet and reference it I get an unparseable error. Any ideas why? =SUMIF({Branch Refresh Schedule}[Target Month]:[Target Month], "February", [# of Devices]:[# of Devices])
-
Is there a formula for within 6 months?
I'm trying to start a formula for this scenario, but am stuck. I'd like to have the column have a green symbol if the date in another column is within the past 6 months. Once 6 months have passed, I want the symbol to turn red. Example: Column 1 Column 2 12/12/22. Green Symbol 4/5/21 Red Symbol Thoughts?
-
If it's blank, Red Symbol. If it's not blank, Green symbol.
I'm trying to get this formula to work correctly. =IF(NOT(ISBLANK([Link to ARP plan]@row)), "Yes", IF(ISBLANK([Link to ARP plan]@row)), "No")) It's not working. Any thoughts?
-
Automated emails are not delivering.
I've set-up several automations to send emails to a contact. When I test, the automation claims to have run, but no emails notification or SS notification is delivered. Note in the screenshot below, it says that this last ran on 2/25/22 at 12:35PM. No notification was received. The odd thing is that I have several alert…
-
Form entry/Copy row automation/Row location
Hello all! I am really hoping this is something easy I am just overlooking. The sheet above has a form. When the form is completed the row of information does not populate in the first available row, but a random row typically 25+. The sheet above had the first row populate at 49 and the automation from this sheet to…
-
IF FUNCTION
Hi, I am trying to automate the full kit complete column to say if the full kit date is in the past, mark complete otherwise incomplete. When I put this formula in below, it gives me an #unparseable error. Any idea what I am doing wrong?
-
Cross Row Matching
I need a solution to match roommates. When they sign up via form, each person enters the email address of their preferred roommate. 1) For each volunteer (Stepheni), I need to look at the preferred roommate (Mike) email, and see if that person has signed up yet. I have this with a vlookup. 2) If the preferred roommate…
-
Pareto Charts in Dashboards
Hello, I have several data sets I'm adding to a Dashboard and need to pareto the results in the charts. The data is entered by traveling employees and the results can change daily. I am new to Dashboards and learning as I go. I searched the community and didn't find a direct formula. Does one exist?