-
How to link specific fields from one sheet to another sheet?
Sheet #1 has two Columns, let's say they are titled "Name" and "Fruit". Under "Name", is a list of names i.e. Mitch, Sarah, Elizabeth, Pete etc. Under "Fruit" says apple, orange, kiwi, etc. I want to create a new sheet (Sheet #2) that could reference Sheet #1. For instance, if column "Fruit" in the first sheet says…
-
Dropdown list Default value
Hello, I have a dropdown list of 10 values, simply a Right First Time stat tracker. So they choose "yes" if the action on the line was done correctly, or choose one of the other 9 reasons on why it was not done correctly. Is there a way i can set the dropdown list to select "yes" as the default value? Thanks Andrew
-
IF Formulas and multiple contact list
I am creating a workflow for a group of people and I want to assign roles when a specific cell (i.e. Doc Type) has been selected. However, I use the formula: =IF([Doc Type]@row = "ABC", "Sahand", IF([Doc Type]@row = "ABCD", "Jamie")) However when the results only show my name within a text format instead of a contact. Is…
-
Duplicate Entry Formula (Not a run-of-the-mill ask)
Hi, I'm trying to create a duplicate entry "Flag" across my database. The database I'm working with is a database of equipment at my company. Here's the scenario: once we log the equipment in the database, that equipment is tied its room (Room A). However, in a year or two, there could be a project that comes through and…
-
How to remove last character in a concatenation
I have a series of columns concatenated, separated by _ (so it looks like "A_B_C_D_E_...") Some all columns after E are optional. The end result means some concatenations end in "_" I think a helper column might be needed, in which case the formula would be something like that solves for 'if row ends in "_", remove "_" -…
-
Formula - Current Week/Last Week
I have been using a formula in one column to capture the current week and last week based upon the created column. I am not seeing my mistake or what I am missing, hoping for some guidance please. However, last week I noticed that the formula is capturing a year ago as current and last. The formula I have been using:…
-
Sum Collect - not working on new blueprint sheets
I am trying to reference a source sheet on project specific sheets rolled up from a control center blue print. I am using Sum Collect to gather the sum of transactions based on Project number, cost code and category. The Sum Collect formula is working on some sheets, but not others. =IF(Summary@row = 1, "", IF(Children@row…
-
How to return the value of another sheet cell, taking into account, values in 2 other cells & sheet?
Hello, I am trying, with a formula, to automatically have a cell checked IF the cell from another sheet is checked too, AND if their ID is the same. Here is my case: I have one "Test Cases" sheet (sheet A). When the tester selects Fail in sheet A, the row is copied to the "Issue List" sheet (sheet B) with an automation…
-
JOIN/INDEX MATCH HELP
Hi all, Is it possible to return multiple values in to a cell based on a match in a cell which may have multiple values? I have 2 sheets - one is my master tracker. I am trying to autopopulate the sub-portfolio Column based on what product or products are selected in the PRODUCTS - OTHER which is a multidropdown column. I…
-
Create a Drop-Down List from Another Smartsheet
Greetings! Does Smartsheet include a feature that allows for the creation of a drop-down in which the selection choices are pulled from a column in another Smartsheet? Thank you, John
