Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Cell linking
Discussion List
-
Answered Tucker Webb 13 views 3 comments 0 points Most recent by Richard Rymill SBP Using SmartsheetFirst post 01/22/20,Last post 01/23/20Hi Smartsheet, I have the following problem. I am a contractor that has to go around a home and take a materials count on a list of tasks say a door install, window install, etc. Anyways, I am trying to figure out the quickest and best sol…Using Smartsheet133Tucker Webb -
First post 11/27/18,Last post 01/22/20I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy. Situation: I would like to have a form where someone selects one op…Formulas and Functions39516Dajah
-
Answered xnickeddlemanx 23 views 5 comments 0 points Most recent by [email protected] Formulas and FunctionsFirst post 01/17/20,Last post 01/20/20Hi Community, I am working with an INDEX MATCH formula to return content from another sheet; however, for each unique value, there are 4 duplicates. For example, an associate completed 4 learning events all attached to the same cohort na…Formulas and Functions235xnickeddlemanx
-
First post 01/17/20,Last post 01/17/20I have multiple sheets(Representing a job) in a workspace that have conversations. I am wanting to combine all of the conversations into one report or sheet to see all of them in one sheet. Can this be done?Using Smartsheet141rwholland -
First post 09/19/19,Last post 01/17/20I have inherited PMO reposinsibility for a large program in Smartsheets. I am going through the process of linking the various schedules, finance/risk/issues registers and other sheets for about 15 projects, all of which link into sub-prog…Using Smartsheet305Kyle Furner
-
First post 01/11/20,Last post 01/11/20I have sheet 1 with cell A and cell B, I would like to manually enter cell B and have cell A auto populate by searching/referencing sheet 2. best, OwenFormulas and Functions133Owen Smith
-
tcanelli41471 46 views 3 comments 0 points Most recent by Andrée Starå Premium Apps and IntegrationsFirst post 03/15/18,Last post 01/09/20Is there anyone that would be willing to work with me on the phone to work through this issue: I've created a sheet that has over 40 columns - it's my "master" sheet that feeds a bunch of reports that will be utilized by differe…Premium Apps and Integrations463tcanelli41471
-
RYG Ball AutomationAnsweredAnswered Melissa Appleman 29 views 1 comment 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/06/20,Last post 01/07/20Hello, I am trying to automate RYG ball based on Y/N responses to other cells OR I could change the Y/N to also be RYG if that would make this possible. Essentially, my overall goal is to automate the RYG ball based on how 26 other field…Formulas and Functions291Melissa Appleman
-
Control Center Link WoesAnsweredAnswered Ezra 21 views 4 comments 0 points Most recent by Andrée Starå Premium Apps and IntegrationsFirst post 01/02/20,Last post 01/02/20TLDR: Needed to migrate project folders to a SysAdmin user after co-worker resigned. Now new projects don't fill into summary sheets properly and project folders are different URLs/Link IDs and can't run Update Reporting on them. --=====…Premium Apps and Integrations214Ezra -
First post 01/01/20,Last post 01/01/20I have a dashboard that surfaces a report in which the duration value cells is blank. The report source data is in a row report. The duration value is visible in the row report. The source the duration value is a sheet in which it is also…Formulas and Functions220Phil Wightman -
First post 12/27/19,Last post 12/28/19I don't know if what I'm trying to do is not possible within the application or if I'm just missing something. I have created a form that the user selects their name from on the dropdown list. On the corresponding sheet, I'd like to popula…Using Smartsheet341Chris Hockey
-
Accepted Answer Claire Rigby 71 views 4 comments 0 points Most recent by Claire Rigby Using SmartsheetFirst post 12/16/19,Last post 12/19/19I need to create multiple project plans with one resource in common so I want to make tasks between the plans dependent on eachother so that the engineer doesn't have overlapping work and if one task is delayed it will impact the other pro…Using Smartsheet714Claire Rigby
-
First post 12/17/19,Last post 12/17/19What about a sheet to roll up all open tasks of each project owners sheets so a managed worked flow to request updates would include all updates needed for all the project owners sheet actions? This way they are not getting a lot of separa…Using Smartsheet279James Gunther
-
First post 03/24/18,Last post 12/17/19Is it possible to reference the latest comment on a row, in a cell? And if we cannot currently do so, could this be considered an additional feature in the future? I would love to see the latest "update" on a project task as opp…Using Smartsheet7513@daniel
-
First post 12/05/19,Last post 12/17/19I am trying to change the drop down value on my Health column based on the current date. Is this possible? ie. If the start date value is in the past, the health column changes to "At Risk" which is one of the drop down choices.Formulas and Functions522TRach
-
First post 12/05/19,Last post 12/08/19Is there any option to set a cell to be both inbound and outbound so that regardless of which sheet I update the cell, the two sheets will be updated? Thanks in advance.Using Smartsheet251leoatucsd
-
Michael Gerdes 23 views 2 comments 0 points Most recent by Richard Rymill SBP Formulas and FunctionsFirst post 12/05/19,Last post 12/06/19Hi, I have an inventory sheet where users are putting products in a box, the user would like to minimize the number of clicks as they are moving large number of products a day but these products will go into several boxes. is there a way t…Formulas and Functions232Michael Gerdes -
First post 12/04/19,Last post 12/05/19I tried searching the boards, but not sure that I'm asking the question the right way. Essentially, I'm looking to know the following: Within the Smartsheet worksheet, I have two columns both set up in a checkbox format. I'd like to restr…Formulas and Functions243Dave Wilderman
-
First post 12/04/19,Last post 12/05/19Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…Formulas and Functions352KDub618
-
First post 12/03/19,Last post 12/04/19Hello, I'm evaluating the use of Forms for a "field ordering" system from an Item Master Table. Best scenario is to create a form to request multiple items via a single submission (not multiple items in a single cell = less desi…Using Smartsheet473SupplyChain
-
First post 12/04/19,Last post 12/04/19Hello All, I am trying to build a graph of data and I was hoping someone had some ideas for me. Scenario: Multiple locations use a form to input data on incidents that occur at their location. The form has them input incident type (from …Formulas and Functions210cthrasher97141 -
First post 11/29/19,Last post 12/03/19I am trying to create an "Assigned To" sheet for each employee. I would like to pull from a contact list column on another page. I want it to return "Alex" if Alex is listed in the column and reference "Job"@r…Formulas and Functions282noclue
-
dwayne.waterman21236 21 views 5 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 12/02/19,Last post 12/03/19Hello, I have (2) fields on a sheet that are driven by dates. here is an example: =if(and(today()>=date(2019,9,1),today()<date(2019,10,1)),"Period 1") So on the first of each month, this field on my dashboard should upda…Formulas and Functions215dwayne.waterman21236
-
First post 12/01/19,Last post 12/03/19Hi, I'm trying to reference contact info from one sheet and have it show up in another as I type. I want the second sheet to search a column as I type and match the contact name if it exists. Does smartsheet have a vlookup or somethi…Formulas and Functions261Michael A.
-
First post 11/30/19,Last post 12/02/19In my 'Install' sheet status column I have a formula =IF(Health3 = "red", "At Risk", IF(Health3 = "yellow", "On Hold", IF(Health3 = "blue", "In Progress", IF(Health3 = "gree…Using Smartsheet251FusiaSuede
-
First post 11/30/19,Last post 12/02/19Hello My organization has finalized our 2020 Capital Ex Budget. Starting in January 2020, I want to create a Capital Exp Form that provides the options that were approved for the 2020 Cap Ex Budget. For example, the form would be set up …Using Smartsheet221Nillie D
-
First post 11/21/19,Last post 11/25/19Hello, I am desperate for some guidance on the best way to handle my situation. First, I have 2 sheets that I'm attempting to provide an executive view for: * First sheet is a forecast that indicates the number of people we should be tr…Formulas and Functions311cyndi_walker108886 -
First post 11/23/19,Last post 11/25/19What am I doing wrong? I am linking cells from one sheet to another. When I do so I select two cells and then link them to two cells in another sheet. However, only the first cell has a link not the adjacent one? Also when I delete the …Using Smartsheet282Phil Wightman
-
First post 11/22/19,Last post 11/23/19Hi There, I am using my smartsheet to manage a production of furniture goods. I have set columns up for Start/ Finish/ Expected finish/ Duration/ and Delay to Expected finish. This will enable me to see where the delays are happening in …Using Smartsheet251ew112261
-
Closed Sarah Link 17 views 3 comments 0 points Most recent by Richard Rymill SBP Archived 2016 PostsFirst post 04/14/16,Last post 11/23/19We are new to smartsheet and looking for advice on the best templates to use to track schedules, and being able to track delays, etc. Would anyone be willing to share ideas or sheets that you have found useful to your business? Thank …Archived 2016 Posts173Sarah Link
