-
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…
-
Automation Workflow run on the 1st of the month
Hi I need to have an automation run on the first of the month based on the approval date and I'm not sure how to do it. For example, if the approval date is done 5/8/23, then the automation should run on 6/1/23. I believe I need to create a helper column that would house the formula to calculate the 6/1/23 date but I'm not…
-
Need help with an NETWORKDAYS formula to pause the day count when a Status is selected
I need help with a NETWORKDAYS formula that will count TODAY() if Escalation Completed Date is blank and pause day count if the Escalation Progress is "Phase 0: On-Hold" and the column for On-Hold Date has a date recorded (and will still count as TODAY() if blank). Current Formula I am trying after searching in the SS…