-
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,…
-
Status change with due date
I cannot get any of the formulas I try to work to update status based on pending end day. Red= < 30 days Yellow = < 60 days Green
-
Workday formula getting an unparseable error
I am trying to calculate the end dates of some milestones. I have a start date column, planned duration column, and end date column. I have holidays in a separate sheet called holiday idle days. Im using the formula below but there seems to be an error with it. Can anyone advise? =WORKDAY([@row]Start Date, [@row]Planned…