-
Update Request - Shows Sending, but Not Received
Hey all - Been using all the great functionality of SS for quite some time now. I have an Automated rule setup so that when a person Submits a certain thing, an Update Request is Automatically triggered. I've had several of our AEs reach out saying they're no longer receiving them, but when I go into SS, I can see that the…
-
Change RYG ball based on multiple conditions
I am trying to change my Overall Health ball Red/Yellow/Green based on the Risk columns. If any of them are High the ball would be red, if any are medium the ball would be yellow otherwise if all are green the ball is green.
-
I'm trying to create a checkbox that will be selected when two criteria are met
Hello, I'm trying to create a checkbox that will be selected when two criteria are met. The criteria that would all need to be met for the checkbox to be selected would be 1) An end Date no more than 90 days away 2) Status that is "In Progress" The formula I have so far is: IF((AND([End Date]1 <= TODAY(90), [Status]1, "In…
-
Formula to check box when 2 criteria are met: older than 180 days and another box is checked
I can't get get my formula to work. I am trying to get a box in one column to check when the date in another column exceeds or is equal to 6 months (180 days) and when another box in a third column is checked. This is what I have, but I think it's the checkbox condition that's throwing things off: =IF(AND([Start Date]@row…
-
Counting multiple columns with multiple conditions
I have a working formula that counts if a task is not complete and due in a specific week: =COUNTIFS([Calc if Done]@row, =0, [End Date]@row, AND(@cell > TODAY(+7), @cell <= TODAY(+14))) This currently returns a 0 if false and 1 if true. Then can sum the Tasks due for particular week. I need to add another condition to this…
-
Difficulties Using ISBLANK Function
Hello, I am curious what I need I need to do, am relatively new to SS and it's functions. We review products, and often times this analysis requires the product to be sent out to a third-party for analysis. I do not want these third-party days (business days only) counted against the lab's time to complete. What formula do…
-
Help dynamic dashboard
Hello, I'm looking for some help setting up a dynamic dashboard. I have a sheet per project with various financial and activity information and I want to create a dashboard where a project manager can enter their project number onto a dashboard and see summarised information for that project. I have tried creating and…
-
I am trying to count only BTAMS received column that are dated with in 15 day of schedule column
I need to count only "B received column" that are dated with in 15 day of "schedule column" but if BOTH dates are in the past of today I don't want to see anything. This what I have so far. What am I missing? I can't even get the first part to function. =COUNTIFS([B Received from WF]@row, >=Schedule@row(15))
-
Need Help with JOIN COLLECT: Need Help by Tomorrow!
How can I collect data from each column and row? Below you will see each column with an associates name at the top. On the side of the grid you will see the list of dates. I need to pull that data to another grid by needing to know on each date what someone worked. Example on 11/02: I need to know how many hours Angela…
-
SUMIFS function with ability to return blank if cell is blank
I am trying to establish a formula that will SUMIFS when multiple criteria is met yet when there is none of the criteria is met, leave cell blank. The formula that I have used in the past included the "IFERROR" function yet it doesn't work =IFERROR(SUMIFS({Battery Scorecard Raw Data 2}, {Location}, "Richmond, KY", {Wk},…
