Hi, I currently have a sheet where we follow up leads / quotes and am wanting to create some formulas, either on the same sheet or in another sheet (so user doesn't see all formulas). I have the follo…
I have a formula that is troubling me. I am trying count between two date ranges so I can count the number of shows due (between a set date ranges or set to count only the next 14 days). The forumla b…
Hello, I'm trying to write a formula that'll allow me to look at the color of the RYG balls in some rows, find the lowest color and set that as the main color for the overall project. So, Project A ne…
Depending on values in one column I want to restrict the dropdown list in another column Example: I have a sheet: Employees Role Name ------ ------------- PM Jane PM John Dev Mark Dev Stephanie In ano…
Thanks for checking this out as my formula game is pretty weak. I am looking to have a formula that will check a box if the create date is 90 days in the past provided another box was checked.Real wor…
Hello Community, I'm trying to get a sum of children cells if a checkbox in another column is checked. For instance, if Column A has row 1 checked, I want the Column 10 row 1 counted as part of the su…
Hi, I have 2 Grids (Sheets) and I would like to insert the formula in every row that counts the rows that are NOTBLANK in other sheet with the same date. Sheet1 has several ROWS with the same dates. S…
I am trying to sum the values of child row if three conditions in adjacent columns are met, from another sheet and post it on my main sheet. I reference a parent row and need to sum the children value…
