-
When Form data is inputted to the sheet, is there a way to input on an existing row?
Every time a form is submitted with data it creates a new row. I would like to populate in an existing row. Is it possible? I looked into automation but could not find a way to do so. Thanks
-
Status formula with check box criteria
I am attempting to add a check box criteria to a Status Column formula. If the PRODUCTION HOLD box is checked, then it is on "PRODUCTION HOLD", if not then it is "RELEASED FOR PRODUCTION". This criteria needs to go first before the remaining production status criteria in this formula. Some error I'm making in the boldedβ¦
-
Why does the vertical axis percentage number change depending on the device used to open it?
I am experiencing an issue with a compliance tracking chart that utilizes percentages on the vertical axis within a dashboard. When viewed on different devices, the chart displays varying total percentages: 120% on my laptop, 100% on my iPad, and 2000.00% on my phone. Could you advise on how to correct this discrepancy soβ¦
-
Parents and children integrity
Hi I have a single sheet that has parents and children. What I was hoping to do is use Dynamic View to allow various people to add rows. I was hoping that it would automatically add/ categorize the rows into the relevant parent group. However when testing this it adds it to the bottom of the sheet. Is there a formula thatβ¦
-
Join/Collect (Distinct?) Help with Combining Separate Line Items Based on Unique Values
So I'm having an issue (lack of understanding) on how to use join/collect to turn a sheet like this: Into one that combines Qty/Supplies into one line item based on data from multiple other columns. End result like this: I would like to get it so that Supplies/Qty get merged when Department, ID Number, Drop Off Location,β¦
-
Nested IF Function Help
I am struggling to get this formula to work. Any thoughts? =IF(([FY26 Membership Level]@row = "Basic", "$2,000", IF[FY26 Membership Level]@row="Enhanced Level 1", "$8,000", IF[FY26 Membership Level]@row="Enhanced Level 2", "$12,000", IF[FY26 Membership Level]@row="Intensive Level 1", "$15,000",IF[FY26 Membershipβ¦
-
Incorrect outputs from my formula revolving dates between rows
Hi, so I am having issues here where this formula is outputting incorrect values It should be finding tasks it overlaps with, then finds how many days they overlap and outputs this I have multiple columns of this for each instance of overlap so if another row overlaps it would be outputed in 2 An example of an issue is inβ¦
-
What am i doing wrong?
I am trying to add data form two columns if they contains set information, however i keep getting it wrong? =COUNTIFS((AND({PTQ-R-021 Actions Log - Corrective/Prevent Range 2}, "Observation"):{PTQ-R-021 Actions Log - Corrective/Prevent Range 1}, "Health & Safety"))
-
Equation to: Look up value from another sheet and return a new value
Hi. I have 2 master data sheets (Sheet A and Sheet B). Both sheets have a column called [Company Name]. On Sheet A, i need an equation that looks at [Company Name] in Sheet A, then searches for a match in Sheet B. If there is a company name match in Sheet B, then I would like to return the value of a different columnβ¦
-
COUNTIF & Multi-Selection Dropdown -- Count multiple entries
My data input sheet has several columns that are Multi-select dropdowns. For my Metrics summary page, I am struggling with COUNTIF when the user has selected multiple options. Example of options in the Multi-selection dropdown: * Apple * Pear * Grapes * Banana * Other I need guidance on how to structure the criteria forβ¦