-
Isolate User Entered Value in Multi select list
I have a multi-select list that looks like the below. My goal is to map form results to a PDF and I've used helper columns to turn the responses into checkboxes [formula for those: =HAS([Indicate the type of referral source]@row, "Yes, parent")]. However….I do not have the multi-select limited to my answers so that staff…
-
Parent row status formula based on child rows
Roll up formula for status I have this formula (shown below) where I am trying to get the status of the parent row automatically entered based on the child row. I'm not sure if I've stared at this too long and my eyes are crossing, but it's not doing what I want it to do. I think I've listed all the permutations below. 1.…
-
Getting data calculations from another sheet
I am trying to create a metrics sheet for my dashboard of how many issues in these categories below, are High Medium Low Open Currently in Pilot Pending Development Pending Production Release Pending Dev Acceptance Review with Third Party Under Investigation Closed I am trying to gather the data from another sheet, but i…
-
Calculate average of mid-range
I am looking to find the average of the middle 50% of a range - excluding the lower 25% and the upper 25%. I am trying to add the formula into a metric sheet, so the formula would reference another sheet. Here is what I thought would work but does not: =AVERAGEIF({Permit issued to constr start}, ">= " & PERCENTILE({Permit…
-
Challenges with combining SUMIFS and COUNTIFS
I am using the Sheet Summary to input formulas helping me to track the COUNT of installs that took place in a given month/year. But now I want to SUM how many assets were installed at that location using the same date criteria. My formulas below are allowing me to COUNT how many rows (AKA customer locations) fit my…
-
Allow Images, Field Formula Calculations, and Layout Customization in Forms
Allow Images: It would be so great to be able to add images to the form layout that can be viewed within the form. This could be used for multiple purposes (ex. Order or Item selection based on image. Ex. Provide visual instruction or assistance to help user complete the form.) Field Formula Calculations: If a form's…
-
Merged: Feature Request – Enable Copy and Paste for Header Columns
This discussion has been merged.
-
formula help
hello all, can I get help with this - I am trying to count the "√" in column DAY 2 but its in a children lines from parent line 03.2025 - that is a children's line for parent line 2025 I don't know what am I doing wrong =COUNTIF(CHILDREN([DAY 2]:[DAY 2] "√"))*8.5
-
Partial Formula Working
Hello, Everyone. I have a commission sheet with many columns, and I have a 3 part formula to calculate commission based on 3 different % depending on which month of the contract the sales team is in. The first two IF statements work beautifully. The 3rd part I need to calculate that if the Month of Contract is greater than…
-
Level 1 Net Days
Hi what column formula can I use in days to sell that calculates the number of days between start date and date marked sold that calculates only on the level 1 main level. I do not need it to calculate the children.