Cell linking

Ask a Question

Can I turn off the "Used in formula on" information screen?Accepted Answer

Accepted Answer Sonny Mendoza 10 views 3 comments 0 points Most recent by Andrée Starå 03/27/20Formulas and Functions

First post 03/27/20,Last post 03/27/20
I have linked many sheets so now when I try and select a drop down within a cell I cannot because this "Used in formula on" window hovers over my select options. Is there a way that I can turn this off?
Formulas and Functions103
Sonny Mendoza
Dynamics metrics across new sheetsAnswered Question

Answered BHannah 16 views 1 comment 0 points Most recent by Paul Newcome 03/26/20Formulas and Functions

First post 03/26/20,Last post 03/26/20
Goal: create metrics for a dashboard that automatically update when new project plans are created in the same workspace. For example: KPI=Number of late deliveries across all projects at a client I can create a metrics sheet and create a …
Formulas and Functions161
BHannah
Date updating to Next Day using Index, Match, Max, Collect FormulaAnswered Question

Answered Amy Arnold 32 views 3 comments 0 points Most recent by Debbie Sawyer 03/26/20Formulas and Functions

First post 03/20/20,Last post 03/26/20
Hi, I'm working with two Smartsheets. (1) One sheet collects the data from a Smartsheet form. I added two columns to this sheet using the Auto-Number/System Feature (under Edit Column Properties). This features stamps new row entries wit…
Formulas and Functions323
Amy Arnold
"Save As New" Not Preserving Cross-ReferencesAccepted Answer

Accepted Answer Rachel Peabody 17 views 7 comments 0 points Most recent by Paul Newcome 03/25/20Using Smartsheet

First post 03/19/20,Last post 03/25/20
Hello, I'm building a sheet in which I'm using lots of cross-references in the sheet summary. I plan to use it as an active metric field to display summary information from data in other sheets. I will need to copy the sheet about 30 times…
Using Smartsheet177
Rachel Peabody
Link Data in a Smartsheet on a Specific Day and Make StaticAnswered Question

Answered Donna T 8 views 2 comments 0 points Most recent by Donna T 03/25/20Formulas and Functions

First post 03/25/20,Last post 03/25/20
I have several 13 Smartsheets that make up a campaign of projects. At the top of each sheet I have some metrics, including the % complete for all the projects, combined, on the Smartsheet. I want to create a new Smartsheet that links dat…
Formulas and Functions82
Donna T
Can Formulas Reference Reports?

UnaB 274 views 11 comments 0 points Most recent by Paul Newcome 03/23/20Formulas and Functions

First post 11/20/18,Last post 03/23/20
I'm trying to see if formulas can reference reports or just root SS. I ran a report for all late tasks assigned to all people in a department. I then wanted to use a COUNTIF formula that would sum up all the late tasks of a certain person.…
Formulas and Functions27411
UnaB
HELP with a large sheet and table layout/conditional formattingAnswered Question

Answered Melisa Dannhauser 32 views 2 comments 0 points Most recent by Melisa Dannhauser 03/23/20Using Smartsheet

First post 03/20/20,Last post 03/23/20
I spent 15 hours trying to organize my data in an efficient way and just can't come up with a good solution. Smartsheet is great but SO limiting if you are used to Excel. I have 200+ sites that each has 31 activities. Each activity has 3 d…
Using Smartsheet322
Melisa Dannhauser
I want sync a field across multiple sheet, being able to edit it from any of those sheetsAnswered Question

Answered Rebecca Larkin-Martinez 30 views 5 comments 0 points Most recent by Rebecca Larkin-Martinez 03/18/20Using Smartsheet

First post 03/13/20,Last post 03/18/20
Use case. 4 sheets Intake Sheet, Prioritization sheet, Resource sheet & Overall Status Sheet When a project is requested it is automatically added to the "Intake" sheet through the form. Status field is New. When we agree th…
Using Smartsheet305
Rebecca Larkin-Martinez
ABSOLUTE CELL LINKINGAnswered Question

Answered WOODY 33 views 2 comments 0 points Most recent by Andrée Starå 03/12/20Formulas and Functions

First post 03/02/20,Last post 03/12/20
Im really struggling with getting an absolute cell value to stay in a sheet or in a sheet summary. maybe im going at in the wrong direction. please help. I have a form on my call centre data sheet that is adding an information line each d…
Formulas and Functions332
WOODY
Counting open tickets based on company name and ticket statusAccepted Answer

Accepted Answer Nick Winkley 17 views 1 comment 0 points Most recent by Paul Newcome 03/11/20Formulas and Functions

First post 03/10/20,Last post 03/11/20
Hi, I'm trying to count the number of open tickets by company name, and the cells I'm referencing are in another sheet. Here's my formula so far: =IF({Maintenance tracking Sheet Range 2} = [Company Name]@row, COUNTIF({Maintenance tracking…
Formulas and Functions171
Nick Winkley
Using VLOOKUP for Approval Requests Across SheetsAccepted Answer

Accepted Answer Darin Smith 30 views 3 comments 0 points Most recent by Paul Newcome 03/09/20Formulas and Functions

First post 02/28/20,Last post 03/09/20
GOAL: 1) Have a secure and error-free VLOOKUP on Sheet B and 2) Run a multi-level approval request automation on Sheet B. DETAILS: I have 2 sheets. Sheet A tracks contracts. It has columns for individuals (contacts) who are designated appr…
Formulas and Functions303
Darin Smith
Copying Workspaces with Dashboards

tcanelli41471 97 views 4 comments 1 point Most recent by Jeffrey Buckley USG 03/03/20Premium Apps and Integrations

First post 05/02/19,Last post 03/03/20
We have a workspace with several sheets and dashboards. We want to copy this workspace for each incident we activate for. Is there a way to have the links within each dashboard automatically update to the workspace/sheet location? Curre…
Premium Apps and Integrations974
tcanelli41471
Combining cells from one sheet into a single cell on another sheetAnswered Question

Answered John Kennedy 27 views 9 comments 0 points Most recent by Paul Newcome 03/02/20Formulas and Functions

First post 02/27/20,Last post 03/02/20
I have a master spreadsheet with many columns (sheet1). From that, I want to create a second sheet with fewer columns (sheet2). The first column in sheet1 is 3 cells combined (=[Column1]1 + "-" + [Column2]1 + "-" + [Col…
Formulas and Functions279
John Kennedy
Cell values export from one project to anotherAccepted Answer

Accepted Answer Cyril_H 37 views 7 comments 0 points Most recent by Paul Newcome 03/02/20Using Smartsheet

First post 02/28/20,Last post 03/02/20
Hello, We are currently managing a construction project with smartsheet and have created a Gantt Diagram and a few Dashboard to monitor several KPIs. The dashboards are updated automatically with every changes in the master project and pro…
Using Smartsheet377
Cyril_H
Notify an assignee that the predecessor has complete his task.

Alexander Wirtz 127 views 4 comments 2 points Most recent by Brett Shapiro 02/27/20Formulas and Functions

First post 03/26/19,Last post 02/27/20
I want to use smartsheet as an international project management tool. One thing is driving me creasy. I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario.…
Formulas and Functions1274
Alexander Wirtz
Using a nested HAS formula within a COUNTM?Accepted Answer

Accepted Answer Tracey Riley 21 views 7 comments 0 points Most recent by Paul Newcome 02/25/20Formulas and Functions

First post 02/25/20,Last post 02/25/20
Hi there! For the life of me I can't figure out this formula! So here is the scenario. I have a grid with a dropdown multi-select column type with different organizational shared service options (e.g. Knowledge Sharing, Project Management,…
Formulas and Functions217
Tracey Riley
Update cells via form or secondary sheet?Accepted Answer

Accepted Answer Xander Brennan 28 views 11 comments 0 points Most recent by Andrée Starå 02/25/20Formulas and Functions

First post 02/19/20,Last post 02/25/20
I have a sheet of contracts with 30 columns (status/progression/etc). The columns are updated by different people in different departments. Is there anyway to create a form that would have a dropdown of the contract ID and then the cells I…
Formulas and Functions2811
Xander Brennan
Quickbooks & Smartsheet

JeremiahHorstick 587 views 13 comments 0 points Most recent by Andrée Starå 02/19/20API & Developers

First post 07/26/19,Last post 02/19/20
So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use. It has many application & the proof of concept exists and we use it. We use it for an approval process (for in…
API & Developers58713
JeremiahHorstick
How to pick the latest date from Table 1 and enter it to the cell of Table 2?Accepted Answer

Accepted Answer Aliaksandr Ilyuk 25 views 9 comments 0 points Most recent by Paul Newcome 02/13/20Formulas and Functions

First post 02/07/20,Last post 02/13/20
Table 1 is a list of products that contains among others columns Trade Name, Country, Crop and Last Modified (Auto). Within the rows, one trade name can refer to different countries or crops. In Table 2 there are only Trade Name and Date c…
Formulas and Functions259
Aliaksandr Ilyuk
Linking Two Sheets to update dynamically When columns are added and removed.

Matt Penta 90 views 4 comments 0 points Most recent by Sherry Xu 02/12/20Formulas and Functions

First post 10/28/19,Last post 02/12/20
I have two sheets that i want to be linked dynamically. EX: Column 1: 1 2 3 4 5 I want to be able to have this column automatically update and be created on the second sheet when it is changed on the first. If for example, I were…
Formulas and Functions904
Matt Penta
Maximum number of cross-sheet references per sheet

Chris McKay 460 views 21 comments 0 points Most recent by Mike McNamara 02/12/20Formulas and Functions

First post 04/05/18,Last post 02/12/20
Dear Smartsheet, Please tell me that the below error is just a soft cap like the 5,000 cell-link limit. I probably have 100 unique cross-sheet references in a metadata sheet I've been putting together. I am about 90% of the way through a…
Formulas and Functions46021
Chris McKay
Formulas Not Autofilling With Form SubmissionAccepted Answer

Accepted Answer Joe Liotta 56 views 5 comments 0 points Most recent by Andrée Starå 02/09/20Using Smartsheet

First post 02/03/20,Last post 02/09/20
I'm having some issues with a formula that refuses to autofill with a form submission. The form is submitting new entries at the top of the sheet and I have two cells below it that contain the formula. According to this help article, it sh…
Using Smartsheet565
Joe Liotta
One Dependency for the start, another for the end?Answered Question

Answered Ron Schaefer 24 views 1 comment 0 points Most recent by Paul Newcome 02/07/20Using Smartsheet

First post 02/06/20,Last post 02/07/20
Hi... I'm trying to set up a project that has a task (weekly update reports) that begins with one dependency (e.g., start of project), and ends with another dependency (e.g., on-site work). There are still some administrative tasks that c…
Using Smartsheet241
Ron Schaefer
Populating a Dropdown List

HankBento 1K views 12 comments 0 points Most recent by AverageUser 02/07/20API & Developers

First post 05/21/18,Last post 02/07/20
Hi, is it possible to populate the contents of a dropdown list from another smartsheet?
API & Developers103212
HankBento
Drop Down List Data Validation

kaitlin 311 views 9 comments 0 points Most recent by jamieG 02/07/20Using Smartsheet

First post 05/22/19,Last post 02/07/20
My team and I are new to Smartsheet, and after 2 days of using the software, have already found a couple of major road blocks that will likely keep us from using Smartsheet. The biggest is the inability to create a drop down list that us…
Using Smartsheet3119
kaitlin
How to populate dropdown value list from another sheetAnswered Question

Answered Robin Soprano 54 views 1 comment 0 points Most recent by Andrée Starå 02/05/20Formulas and Functions

First post 02/05/20,Last post 02/05/20
I have a list of employee information in one smartsheet. In another smartsheet, I'm recording events/things about employees. I'd like to have a dropdown list that have the list of employees names (from the other sheet) that I could use t…
Formulas and Functions541
Robin Soprano
Import related data into Master registration sheet?Answered Question

Answered Megan Faulkner 24 views 5 comments 0 points Most recent by Andrée Starå 02/05/20Formulas and Functions

First post 01/30/20,Last post 02/05/20
Hi all! I am making a registration form for students who will be attending a summer camp. Because they are minors, we need agreements (I am structuring these in a simple "check the box if you agree to the code of conduct" format …
Formulas and Functions245
Megan Faulkner
Auto fill a second column based on a drop down selection using a form

Dajah 1.2K views 17 comments 0 points Most recent by Andrée Starå 02/04/20Formulas and Functions

First post 11/27/18,Last post 02/04/20
I 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 Functions116917
Dajah
Conditionally changing cellsAnswered Question

Answered Scott Rae 39 views 6 comments 0 points Most recent by Andrée Starå 02/04/20Formulas and Functions

First post 01/31/20,Last post 02/04/20
Hi, I'm looking to see if there is any formula(or anything else) I could use to change a cell to a specific pre-defined value, if a different cell is CHANGED TO a certain value. I know that the changed to functionality is available through…
Formulas and Functions396
Scott Rae
Totaling across summary sheets

dave.hoffman25926 59 views 5 comments 1 point Most recent by TRMakai 01/30/20Using Smartsheet

First post 10/04/19,Last post 01/30/20
I have created summary sheets in several of my departmental sheets to take the place of the metric section at the top. How can I summarize across all of the summary sheets? I see I can pull them into a report, but I cannot add a Totals o…
Using Smartsheet595
dave.hoffman25926

Ask a Question

Cell linking

Cell linking

Discussion List