-
Too many cells referenced - Need formula revision suggestion?
Hi, I hope some of you all had a great Engage. It was my first and very helpful. As soon as I got back, I started using DataTable to solve for a big problem I've been having with a voluminous sheet, but found that my formulas are still too referential ... according to the warning below. The TLDR is that I think my formulas…
-
How to change count to percentage in stack bar chart?
Hi SS Community, I have attached two stacked bar charts I created for showing status of part shipments between sites. An example of the formula I used in my supporting sheet is: =COUNTIFS({X-Site Shipping Status}, "Delivered", {X-Site Build Stage}, "POM to IHA") If it is a formula issue, what do I need to add/change about…
-
Need help applying AvgIf and/or AvgCollect
I am trying to find the average of a column with specific criteria. I have avg TAT and I am trying to find the average when the Run Type is specific.
-
Creating a formula to track number of days but with a catch
So I have been tasked with creating a formula that tracks the number of days an element is "No". However, there are multiple forms submitted each day so I do not want to count the number of times a "No" is selected. It needs to be a formula that counts the consecutive days but then resets to 0 if the element has a "Yes"…
-
Pre-Populate Form with Entire Field from Sheet
Hello Community, I am trying to figure out how to pre-populate a form with a multi-word field. I know how to populate the form with a field and can provide part of my formula below, but it only brings in the first word of the field and not the entire thing. Can someone please let me know how to bring in the entire field?…
-
Formula for multiple columns - Incorrect Argument Set Error
I have spent more time than I'd like on this formula. I keep getting a #Incorrect argument set error. I would like to provide different direction based on when specific columns have a yes answer. It was working fine until I added the final column Used to Provide Information - Handout. Now I can't get the formula to work…
-
Schedule Health | Average RGYB symbols
Hello community, I have created a schedule health column in my schedule and used the following formula to calculate the row health: =IF(Status@row = "On Hold", "Gray", IF(AND([% Complete]@row = 1, TODAY() >= [End Date]@row), "Green", IF(AND([% Complete]@row < 1, [End Date]@row = TODAY()), "Yellow", IF(AND([% Complete]@row…
-
Question about Functions and Automations
Hi - I have a formula that calculates whether or not an end date has passed by more than 7 days using the TODAY(7) function. If it is greater than 7 days, then a checkbox is checked. That checkbox is used to trigger an automation which sends a notification to a user. My question is whether or not I have to have the sheet…
-
INDEX(MATCH formula issue
I am trying to use helper columns to consolidate form submissions onto the top row of a sheet, in order to use Document Builder to populate a PDF with the inputs from eight different sessions. There are about 10 columns per session. In the screenshot below, the "Which Session" column is a drop-down list with radio buttons…
-
Need help in formula for counting only if a specific text is within a cell
Hello, Please see the image below. I would like to count the number of Journal Articles but only those with the status "Accepted for publication(attach final pdf copy)". Currently, I am using this formula in my Sheet Summary - =COUNTIF([Activity Type]:[Activity Type], "Journal Article"). But it is also counting the Journal…
