-
Formula Error
I am trying to highlight and mark duplicate records with the newest Created Date, but I am getting this error... #Incorrect Argument for this formula... =IF(COUNTIFS([Order/Work Order ID]:[Order/Work Order ID], [Order/Work Order ID]:[Order/Work Order ID], [Order/Work Order ID]@row, [Created Date]:[Created Date], @cell <…
-
Sheets with cumulative values
Sheets with cumulative values We want a low-maintenance sheet that Uses column formulas Accepts new rows via forms Contains a running total in each row (e.g. budget minus spend) This would allow each row to show the diminishing budget — a burndown report. We found this answer by Leibel S. that is letting us create column…
-
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…
-
Stumped trying to add OR to an otherwise working equation
Hello, I have a working equation that I need to take one step further, but have had no luck with my attempts. I have a Status column that in it's simplest definition needs to return the values "Complete", "In Progress", or " " depending on the values in two other columns; ACTUAL START and ACTUAL FINISH. The list of initial…
-
Simple Iteration
Please add iterators either from workflows or cyclic cell reference. For example if I wanted to increase a cell named [Count] by 1 every time a checkbox named [KPI] is checked, I could write a formula into [Count] such as: =if(KPI@row, Count@cell +1) and then set a workflow to uncheck KPI. This could also be done with a…
-
Today Formula Working and not Working
Hey Folks, I'm having trouble the column HELPER|Today & Safety Issue (Not R/Y). That column should only say "Yes" when the submission was for Today, the HELPER|Today & Staffing Level is Blank and the Safety Issues is "Yes". The formula in that column works for the past submissions and todays submissions but is saying that…
-
Lookup highest amount with conditions
Hello, I think I am close but I am not sure how to add one more value to look up one more piece of the puzzle (country data) from the current formula I am using. I am not sure how to reformat the formula so that the formula also looks at the country. I am currently using MAX and COLLECT to check three columns (Role, Hourly…
-
Any idea on using OR function with SUMIFS?
Hi Smarties, I understand we can use OR function with SUMIFS or COUNTIFS - I just couldn't figure out how. I am wondering if there is a solution to the problem below "OR can be used directly in a boolean column (checkbox, flag, star) or can be used within another function—such as IF, SUMIF, COUNTIF, SUMIFS, and COUNTIFS."…
-
Return a Contact from another Sheet based on value
Hello, I have a source sheet (Sheet A) that maintains a list of projects and assignments. I need a second request sheet (Sheet B) to intake requests. On this sheet, the project name will be included. I would like to use a formula to output the name of the assigned staff member for that project (found in sheet A). (*the…
