-
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…
-
Creating a points sheet from a previous query (issues with formula/sheet referencing)
Hi Everyone I have kindly had an issue relating to scoring answers on a multi-select dropdown https://community.smartsheet.com/discussion/104030/subject-adding-weighting-points-to-answers-within-a-multi-select-dropdown#latest However due to the volume of questions I'm looking to include, I want to create a separate points…
-
How do you enter a long formula?
Hello, I have quite a long formula, I wrote it in Word... When I copy and paste, the cells used in the formula are not highlighted, so I think the program doesn't recognize them. Therefore, I am copying my formula by hand. However, when I am at about the second or third line and I click on a cell to use it in the formula,…
