-
Emails incorrectly captured
Hi, I have created forms where emails must be captured which is then used in automations. Now my client has asked what happens and how can they be notified when a email (Notification) is not send due to a email incorrectly captured. Example - peterpan@gmail.com will be validated (assume correct email) and…
-
Asset Utilisation Help
Hi all, I'm trying to create a summary sheet which pulls data from a separate sheet populated from a form. Basically I want to match and return when an asset was last used (a date - the most recent date to be precise within the last 7 days). There can be multiple assets in the same cell which is kind of stumping me, I.E…
-
Check Marks
I need a formula that works for the following: For a column with check marks - IF the cell has a checkmark/star, count it as 1.
-
Auto adding Cells to one singular Cell when a column is triggered.
Hello, I am trying to figure out how to Add cells to another cell when a column is triggered. I have a column of numbers that I need to add to another cell as soon as that row changes to another statuse. For example; The Statues column, when it changes from drafting in progress to drafting completed. I need a cell in that…
-
How to get vlookup to not lookup search value is blank
Hello - I have several sheets that link together. The Client Profile is the "master sheet" were 85% of data is contained. As a new client is added, a client # is assigned to that person. Then on the next sheet - the Account Profile sheet, we enter the assigned client # and I have a simple Vlookup. We ran across an issue…
-
Is there an issue with using an IF statement across multiple sheets?
Hello, I am having trouble using an IF statement across multiple sheets. Basically, IF a row has a specific word, it should pull the column I need. Or was there never a link like this before? Thank you!
-
How can I use an IF statement with INDEX/DISTINCT?
Hello, I am trying to pull distinct information from a different sheet if a box is checked. Here is my formula to pull in the distinct information: =IFERROR(INDEX(DISTINCT({Source Sheet Column_Name}), ID@row), "") Now, I have a checkbox column called AX S2 and I just want the information from the rows that are checked in…
-
Creating a Dashboard using Formulas
Hello, I'm currently working on a dashboard (first time doing this, too) and one of my reports need to read how many documents were either approved or resubmitted per month. I know I need to create a new sheet in order to create the Chart. I do already have a sheet that states how many were approved for each month but not…
-
Index Match Row Number Update
Hello, I have an index match formula but when I drag it down, the row number doesn't get updated and just drags the same formula down. Is there a way to drag this down and have the formula update rows? Formula: =INDEX(COLLECT({OSS Test Range 1}, {OSS Test Range 4}, "New"), 1) I'm referring to the number 1 at the end of the…
-
Nested IF with multiple functions included returning unparseable
I have a complex sheet along with a Metadata sheet and wanting to add certain results according to the following formula. =IF(UPN@row <> "", (IF(CONTAINS("VFD", [Equipment ID]@row), "1823", (INDEX({Cardinal Metadata - UPN & UPI List 'WBS'}, (MATCH({Cardinal Metadata - UPN & UPI List 'UPN'},@row, 0), 0))), "") No matter…