-
Index & Match Formula to provide row number if found in column
=IF(INDEX(ColumnA:ColumnA,MATCH(ColumnB@row, ColumnB:ColumnB,0), INDEX(Auto:Auto, MATCH(Auto@row,Auto:Auto, 0), ""))) Auto = System column to pull row number ColumnA =Text ColumnB =Text ColumnC= Formula location & Row Number Output So, what I’m trying to achieve is to have a formula to Lookup ColumnA text and match ColumnB…
-
Counting selected dropdown elements with Collect function?!?
Hey all, first time caller, long time listener. I have a sheet (Sheet 1) that has a drop down column, the user can select any or all of 26 elements. In the same sheet I have a column titled agents with 15 agents in a drop down multiselect cell. This sheet has over 900 rows on data. In a metric sheet (where I am aggregating…
-
Nested IF formula with input from 2 different columns possible?
I am stuck on a nested if formula. I have 2 columns that set 1 of 3 statuses in a 4th column, here is the basic break down if "APPR'VD BY ARCH'T" is blank, display Awarded in "Project Ordering Status" column, if "APPR'VD BY ARCH'T" is a date, display ABA in "Project Ordering Status" column. Here is the formula that I have…
-
Help with formula
Hello All. Can any of you help me with this formula. I need to add the finish date to display next to the construction phase in the sheet summary. The sheet summary for each month has formula. Below is the current formula which works and displays what is in the sheet summary. I just want to be able to list the finish date…
-
How to Count how many times a cell is in a column
I am struggling with a formula how many times Delta appears in the Client Column. The formula I am using is: =COUNTIF((Client:Client), FIND("Delta", Client:Client, >0))
-
Batch Notifications - How to enable
I have a workflow that is running hourly with the goal to batch the notifications rather than send a notification for each change. In this example below, the end user is receiving the same number of notifications as changes (row 52 and 52). The end user is making a high number of changes at once that can result in an…
-
How can I automate task creation?
I'd like to automate the assignment of tasks upon reaching 90 days of a due date. I've figured out how to create a cell with the trigger date, subtracting the default period from the due date, but I can't figure out how to automate the task creation in a different sheet.
-
Can someone help me with a date formula?
I have a column that shows how many days have passed since a start date. I would like to add a column with an end date, and if there is an end date, have that count stop. So if the end date is blank, the count will keep going up. If the end date is entered, it will show how many days passed between the start date and the…
-
Can I use dates in another sheet to calculate the difference between two dates (NETWORKDAYS)?
I am trying to calculate the number of workdays between two dates, but the dates are in another sheet. I thought I could create a simple NETWORKDAYS formula referencing the two columns with the dates in the other sheet, but only get back an INVALID DATA TYPE error. Both referenced columns are DATE type, the column with the…
-
Formula Help - Check the box once per unique ID
Hello - I will try my best to explain my formula question. I am using DataTable to import a few hundred to a few thousand rows of data monthly into a targeted sheet. After 180 days from a specific date column, they roll off the targeted sheet. My goal is to show the Unique Rows like the "delete duplicate" functionality in…