-
How do you have multiple cells populate when drop down column is used?
First of all, not sure if this doable, but I'm sure it has to be. I have 2 sheets. On the first sheet, we have a column in which multiple people can be checked it looks like this: We then have a second sheet in which we use index match formulas to populate the address with the appropriate name. What happens when we select…
-
Using Variables within Formulas
Hi, Is there a way for me to replace "Akeneo - Adobe Exchange Account Alignment" with a variable AND substitute "Range N" with a column name in the formula below? Note that Industry1 is a variable. For Example: Here's my formula. It works but I have to edit it for each Smartsheet reference of which there are many.…
-
Concatenate Parent and Children Names
Hello All, I am trying to get a column to concatenate the Parent and Child Names For example, In my primary column I have 12345 AA BB. CC In another column I would like it to Concatenate the names 12345 12345 AA 12345 BB 12345 CC in excel it would be =Concatenate(Parent & Child) I tried =(Parent() + Child()) Still no go.…
-
COUNTIFS on a cross sheet formula with ISDATE function
=COUNTIFS({PBR}, main@row, {request date}, YEAR(@cell) = 2020) The above works fine, but when I add an ISDATE function (below), fails. =COUNTIFS({PBR}, main@row, {request date}, YEAR(@cell) = 2020, {complete date}, ISDATE(@cell)) What am I doing wrong? I only need to count records with a completion date. I've also played…
-
There´s a way to copy a row to another sheet with a if formula?
Hi everyone, i have a group of four sheets and i want to copy specific rows to another sheet. I have a column called "FORMAL RECLAMACIÓN" and i want to copy the entire row to another sheet if there´s a date on this column. Is this possible?
-
Counting Contacts in a Cell
I want to count the number of contacts selected in a column. Is there a formula to do this?
-
Forms Logic
Good Morning: I am trying to find a way to implement conditional formatting to a form - based on a selection additional field would populate. When I looked on Smartsheet, it stated that you could do this under "Logic" within the forms design. However, I don't see "logic" as an option available to me (NOTE: I am in the…
-
RYB Inventory Tracking
Hello all, I am trying to make a formula with RYB for inventory tracking. Green will show when QTY ON HAND > QTY, and CURRENTLY ON ORDER = Yes Yellow will show when QTY ON HAND is less than 5 Red will show when QTY ON HAND is less than 2
-
Countif by Month in Created column
Hi - I'm looking to figure out how to use my Created column to count items that are Main Row "true" and happened in the month of June. I tried messing with the following formula but came up unparsable - my favorite error :-( =COUNTIFS([Main row]:[Main row], 1, Created:Created,MONTH(@cell), 0) = 6) I figure I've left a…
-
SUMIFS Function for multiple condition in a column with multiple criteria
Hi Team, I am working on a data wherein I have Value in CSPBU Boost Requests Range5 that need to added only when Criteria1 - if CSPBU Boost Requests Range3 is Approved inn a Column, and if In CSPBU Boost Requests Range2 either we have Lost or Cancelled. =SUMIFS({CSPBU Boost Requests Range 5}, {CSPBU Boost Requests Range…