-
Counting individuals supported by specific customer removing repeats
Hi, I am trying to sum the number of individuals that are supported by a customer. There are several opportunities that support a single customer and within these opportunities the same individuals may be supporting the customer. How do I calculate the unique number of individuals who support a single customer. The…
-
Is there a way to create an automation to change a cell to a formula?
I'm trying to copy data from column to another, but only if certain conditions are met (i.e. if a separate column is checked or has a specific drop-down selection). I tried creating an automation with conditions that writes a formula to copy the cell into the column I want, but it adds a ' to the beginning of each function…
-
Formula for distinct or unique totals based on multiple criterias
I am creating a table to collect total REPORT KEYS that are unique month to month for each dept, each division and with unknown total transactions in each report key (we don't need to know how many transactions in each REPORT KEY). The data set can include up to 100 REPORT KEYS with no set amount of transactions for each.…
-
Dropdown List Per Cell Using API?
I have been doing a ton of research on how to do a dropdown at the CELL level, instead of column level. All signs point to this being a lost cause, as the feature has been being requested for 5+ years now. However, one forum response indicated this is possible through API. Does anyone know if this is the case? If yes, how…
-
Dynamic Dropdown List
Has anyone created a workaround or built a solution that provides dynamic dropdown lists?
-
What is missing from the below if formula?
=if(@row23 = Y, "0.1", "0") I am wanting Smartsheet to put 0.1 in a cell if the reference cell is a Y and 0 if the reference cell is a N.
-
NETDAYS returning #INVALID DATA TYPE
Hi - I'm trying to calculate the number of days between two dates in a sheet. I have both of my columns that contain the start and end dates set up as DATE column type. They both contain dates. I use the formula "=NETDAYS([Hotel Check-In Date]@row, [Hotel Check-Out Date]@row)". I have tried making the results column a…
-
If, And, Or formula
Looking to calc MQLs if FY = FY24 (easy part), but each region has a different conversion rate and that's where I'm struggling. My formula is something along the lines of: IF ([FY]@row = "FY24"), and (or ([Region]@row is "ANZ", multiply [Lead forecast]@row * 25%), ([Region]@row is "ASEAN", multiply [Lead forecast]@row *…
-
Multiple IF Statement Returning Different Text
Hi Everyone, I am trying to write a formula that will look at a cell and if certain wording is not in the cell then return a value to a new cell. The information is from a multiple dropdown selection column. Here is an example of what i am trying to do. Dropdown List Would Populate the Missing Color column based on a…
-
Gant Chart - How can we track the planned versus actual LAG days?
Hello Everyone, I appreciate any help on this topic. I am starting a study of our construction efficiency looking at our last 30 projects. One of the data points we are digging into is our "planned" LAG days between certain trade partners. (LAG days are inside of our defined working days, and do not include non-working…
