-
Formula cell limit
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?
-
Finding the closest date today with 2 columns of dates
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([Release]:[Release ], [Live]:[Live], >TODAY())) With the same results. Any help is much appreciated.
-
Include ALL excel functions in SmartSheets
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 age] [A:] 85 I figured out that the following formula works when you export the data into Excel but does not work in SS…
-
Auto Add Contact with IF Formula
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 me to create a formula? Every version i have tried has not worked. Thank you!
-
Portfolio Metrics and Dashboards
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 sheet) creates my weekly status report template. Any reason you guys can think of that would make all of my formulas freak out…
-
Assign multiple people to a row, based on multi select drop down.
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 customer, the customer managers I am trying to pull in are on this sheet. So I need the formula to look at all the customers…
-
Help on NOT function within COUNTIF(S)!
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 of chems within the Chem column, but I don't want it to include a specific chem, WOS, AND I don't want it to count blank…
-
Formula needed to count occurrence of a field value across multiple sheets
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 Value Proposition) In Sheet D (which is a Metrics Sheet) I need a formula to count the number of times that a Value…
-
COUNTIFS with DISTINCT/COLLECT
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 both unchecked. There are several rows for the same client as there are different type but here, we want to count the number…
-
Text String Question
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 column trying to create, I would just need 59552 from59552 -Martin Tractor or 178874 from 178874 - BROOKS TRACTOR INCORPORATED