Formulas
Discussion List
- Help! I hit the 25000 cell limit when doing formulas .is there a work around or a way to get limit lifted with business license?
- Hi, I am working on a formula to show the next date from 2 rows of dates. I tried =MAX(COLLECT([Release]:[Release], [Live]:[Live], >TODAY())) - and it showed a date from the past. I tried =MIN(COLLECT…
- Hello, I spoke to a very helpful representative who was trying to help me extract ONLY the data that follows the "[A]:" below that pulls into one cell of the SS: [Q:] What is your age? [please list ag…
- Hello! I am trying to get a contact to auto populate IF a column equals a certain value. For Example: So if the GC/Owner = Gallo Mechanical, LLC i want the "Submit to" = the AP contact. Can you help m…
- Hey all! I just presented the new dashboard solution to the leadership team when I noticed the dashboards aren't picking up anything from the meta data sheet (which in combination with our intake shee…
- Hello, I have a dropdown where the user can select multiple customers. I need to assign the person or people responsible for the customers selected. I have a customer list sheet and each row is a cust…
- Hi all, I am trying to create a formula for a sheet summary. I have a "Chem" column that is populated from a form, and could be any one of 26 chem types. I want my summary to return the total number o…
- Scenario: Sheet A contains a field : Value Proposition. There are 8 rows in Sheet A. VP1 VP2 VP3 etc Sheet B and Sheet C have long lists of tasks, each task is assigned a Value Proposition (in field V…
- Hello all, I've been searching for an hour and I can't seem to find the proper solution. Here's an example : I need to count the number of DISTINCT Clients if Rep is John and Renewed and Refused are b…
- Hello All, Quick question I just need this 4-6 digit number before - Retailer in this column but cannot get my formula to work since what I am pulling ranges from 4-6 digits. For example In my new col…
