-
COUNTIFS across sheets
Hi, I am trying to pull data from two sheets into one, where it will be used to support reports. Is this syntax correct for this? I'm getting the incorrect argument set error. =COUNTIFS({JDP Attribute}, "Safety & Reliability; 1.1 Reliability of gas service", {2022 CSAT Comms Range 2}, "Safety & Reliability; 1.1 Reliability…
-
T-minus dates when going over to next year
Hi. We utilize a t-minus template and it works great until I move where the launch date is in next year and today's date is in this year. =WEEKNUMBER([T-Minus Date]2) - WEEKNUMBER([T-Minus Date]3) + "" I've tried manipulating the basic formula but to no avail. Probably a rather simple change, but I'm stumped. A manual calc…
-
How do i cross reference several sheets to pull duplicate data?
Hello, We have 4 business units and different physicians and hospitals we work with. I want to pull a report for overlapping physicians and hospitals across all 4 businesses. I can see the overlap in a report, but how can I highlight the overlap in Physicians and hospitals in separate reports? Thanks!
-
Help with IF, OR, NOT, ISBLANK
Hello, I'm trying to get it to check these columns and if even one of them is not blank, then populate "1" into the column: =IF(OR(NOT(ISBLANK([WHS: Enter Date Received]@row)), NOT(ISBLANK([WHS: Enter Lot]@row)), NOT(ISBLANK([IQA: Inspector Email]@row)), 1, 0)) I keep getting the #incorrect argument error.... Any tips?…
-
Health Formula
I need to build a health formula that is based on the "Target End Date" and "Status" columns. If the status is "Not Started" or "In Progress" and the target end date is >=today +1 then "yellow", but if it is MORE than today +3 then "red" otherwise leave as "green" Any thoughts? I'm sure and IF(AND combo is needed, just not…
-
Can't get this nested IF statement to work
=IF([Cost Incurred / Hired]@row = "Remove Cost", IF(OR([Spend Bucket]@row = "Blue Badge", [Spend Bucket]@row = "Red Badge"), -1, IF(OR([Cost Incurred / Hired]@row = "TBH", [Cost Incurred / Hired]@row = "Cost Incurred / Hired", [Cost Incurred / Hired]@row = ""), IF(OR([Spend Bucket]@row = "Blue Badge", [Spend Bucket]@row =…
-
Can I use Or more than once in a sumifs formula?
the formula below sums the time served column for just " SPD minor" for January and does not add zeroes to my dashboard. I would like to combine the time served for SPD Minor, SPD Major and SPD continued. =IF(SUMIFS({N TS}, { N Intervention}, ="SPD minor", { N Date}, YEAR(@cell) = 2022, { N Date}, MONTH(@cell) = 1, { N…
-
IF function with column formulas
Good morning, Is there any way to change the syntax on this formula so that it can be made into a column formula? Thanks!
-
# of tasks based on due date and owner
What Smartsheet formula would be best to get the count of tasks due within 10 days if the owner equals "client"?
-
Automation email needs to embed a button to open a FORM
Hello I was trying to set up an automation and be able to embed a button to open a FORM ( that needs to be filled out to report a status See my sample below Hello {{Delivery Lead}} from {{Consumer Team Name}} Please provide your weekly updates via the "Open Update Form" button below for requested fields for requested…