Formulas
Discussion List
- I have child rows that use a formula to calculate % completion based on input to another column. I'd like the parent row to return a value based on the child values (Specifically, sum of the child row…
- This seems like such an elementary question but I keep going around and around on this and I can't find what I'm doing wrong. I'm trying to count the number of parent rows in the sheet (each parent ro…
- I have been looking at the various conversations on using a COUNTIFS with an embedded CONTAINS function, but have had no success getting it to work. In the below formula I want to count "FAA Domestic"…
- Hello, First time asking a question. Forgive brevity/waffle! I have been struggling to understand the syntax issue I have when trying to generate a T-shirt size based off the 'Duration [Days]' column …
- Hi all, I have a box with a dropdown menu with 3 options but you can put multiple items into the box. The dropdowns are GPA PACE Max Time Frame I have 3 columns check "gpa" check "pace" check "Time Fr…
- This might be my first real contribution to this community, but I think I have had a breakthrough with respect to background auto refreshing a sheet. I've seen the common solution of utilizing a workf…
- Hey folks, I'm hoping you can help me solve a mystery. I have about 30 sheet summary fields all using the same formula, which counts two types of responses in each column. I copied and pasted the basi…
- I have a use case where I have a list of dates and need to count the number of rows that do not have a date in the column. For example, 12/01/23 12/02/23 12/03/23 Active 12/05/23 Not Active 12/07/23 (…
- Hello There Community I need help with stringing variables together I am using the following formula: =COUNTIFS({GDS}, "Sabre", {Status}, "Open", {Airline}, (CONTAINS ("AA", (OR ("ALL"))))) Everything…
- I'm trying to create a formula to calculate points and I can't seem to get it right. This is what I have: =IF((Occurrence@row = "Tardy", 1), IF(Occurrence@row = "Late", 2), IF(Occurrence@row = "Half",…