Cell linking

Ask a Question

Reproducible HyperlinksQuestion

Answered - Pending Review Dennis Knipfer 19 views 3 comments 0 points Most recent by Mike Wilday 05/27/20Using Smartsheet

First post 05/27/20,Last post 05/27/20
I'm compiling a hyperlink section to include at the top of project sheets, a little more than a dozen in total. This collection creates my tabbed "Excel report". It will allow end users to navigate to the tabs/sheets they need. I…
Using Smartsheet193
Dennis Knipfer
DataMesh - Duplicates In Source SheetQuestion

Question Mike Rini 7 views 0 comments 0 points Started by Mike Rini 05/27/20 Premium Apps and Integrations

First post 05/27/20,Last post 05/27/20
I have a DataMesh sequence that I run that where the source sheet can have 1 to N number of entries, and it's valid. As I understand it, DataMesh only allows me to select two options - Pick First Match and Ignore Entries. In either of thos…
Premium Apps and Integrations70
Mike Rini
Dynamic Data Validation with Columns from another GridAccepted Answer

Accepted Answer Benjamin Hatmaker 9 views 4 comments 0 points Most recent by Andrée Starå 05/27/20Using Smartsheet

First post 05/26/20,Last post 05/27/20
Hi, I want to be able to validate data in a drop-down menu in one sheet from a column in another sheet. EX: I have a sheet that serves as a master sheet of projects and the project's properties (Name, budget, etc.), and another sheet that …
Using Smartsheet94
Benjamin Hatmaker
Auto Generated Number ReferencingQuestion

Answered - Pending Review Amanda Berta 19 views 3 comments 0 points Most recent by Andrée Starå 05/26/20Using Smartsheet

First post 05/22/20,Last post 05/26/20
Hi, I noticed when using Index match on auto generated numbers something weird happens. On sheet A I use Index({desired result Sheet B}, match(sheet A @row, {search Criteria Sheet B},0),1) where Sheet A @Row is an auto generated number an…
Using Smartsheet193
Amanda Berta
Get a list value from another sheet

Jonathan Vo 478 views 11 comments 1 point Most recent by Andrée Starå 05/22/20Formulas and Functions

First post 04/22/18,Last post 05/22/20
Hi All, I have a sheet of drivers list. And in another sheet, I want to create a column which get driver name from drivers sheet. Can I do it in smartsheet? Thanks
Formulas and Functions47811
Jonathan Vo
When saving as new, I want to break links including sumifs but I'm having an issueQuestion

Answered - Pending Review Jennifer Murphy 10 views 1 comment 0 points Most recent by Paul Newcome 05/21/20Using Smartsheet

First post 05/21/20,Last post 05/21/20
I have a sheet that's linked into a pivot sheet via a series of sumif cross sheet formulae. This sheet is looking into the pivot sheet at a point in time e.g. month of April YTD information, and the Pivot will update monthly as new data i…
Using Smartsheet101
Jennifer Murphy
VLOOKUP HelpAccepted Answer

Accepted Answer ICue 61 views 5 comments 0 points Most recent by Andrée Starå 05/21/20Formulas and Functions

First post 04/15/20,Last post 05/21/20
I'm trying to write a formula in my driver sheet that will search for an employee ID number in the completion sheet and return the text from a column within the completion sheet. I wrote the following but it returns a #NOMATCH value if th…
Formulas and Functions615
ICue
Calculate the time between two dates by days, hours and minutes

LouiseM 803 views 25 comments 0 points Most recent by remkin 05/20/20Formulas and Functions

First post 06/06/18,Last post 05/20/20
Hi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basicall…
Formulas and Functions80325
LouiseM
Use data from a form field in the alert email title.

Roderick 43 views 4 comments 0 points Most recent by Andrée Starå 05/19/20Using Smartsheet

First post 06/12/19,Last post 05/19/20
Setting up an alert system that sends out notifications when a form has been completed. To streamline the process I would like to use a field from the form in the email title to differentiate between the emails rather than a range of emai…
Using Smartsheet434
Roderick
Pulling Multiple Rows of Data into 1 CellAccepted Answer

Accepted Answer LFa 19 views 5 comments 0 points Most recent by LFa 05/19/20Using Smartsheet

First post 05/18/20,Last post 05/19/20
Hello, Does anyone know how to pull multiple rows of data into one cell? I'd like to build a cell that look-up the date "05/20/20" and brings all the values into one cell. https://us.v-cdn.net/6031209/uploads/406/WAOG868Y6EF6.pn…
Using Smartsheet195
LFa
I want sync a field across multiple sheet, being able to edit it from any of those sheetsQuestion

Answered - Pending Review Rebecca Larkin-Martinez 46 views 8 comments 0 points Most recent by Andrée Starå 05/16/20Using Smartsheet

First post 03/13/20,Last post 05/16/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 Smartsheet468
Rebecca Larkin-Martinez
Helper Column FormulaQuestion

Answered - Pending Review Emmet McKenna 21 views 1 comment 0 points Most recent by Andrée Starå 05/14/20Formulas and Functions

First post 05/14/20,Last post 05/14/20
Hi, I want to use a helper column to uncheck a Checkbox column if a certain condition is met. i.e. If [Order Date] contains a date then [Order Required] is unchecked. I can't put the formula into the [Order Required] column as it already …
Formulas and Functions211
Emmet McKenna
Has anyone found workaround today() doesn't involve zapier

azaidi102336 34 views 8 comments 0 points Most recent by Andrée Starå 05/14/20Using Smartsheet

First post 09/06/19,Last post 05/14/20
We want functionality where "Milestones missed in Last 30 days" are highlighted. We can identify Milestones. What functionality do we use to count the rows that have missed the milestone? I've seen responses about Today() functi…
Using Smartsheet348
azaidi102336
Validations/checks before changing the status of a rowQuestion

Answered - Pending Review Roger 13 views 3 comments 0 points Most recent by Andrée Starå 05/14/20Using Smartsheet

First post 04/20/20,Last post 05/14/20
Hello, First of all thanks in advance for support. I have a question, which i think is basic.... but i haven't find the way to solve it. I have a sheet with a status column, then i have 2 columns for KPI values: Status, KPI1, KPI2, start …
Using Smartsheet133
Roger
How do you create a contact list based on 2 seperate sheets using a Vlookup.Accepted Answer

Accepted Answer Garrett Ricker 16 views 1 comment 0 points Most recent by Andrée Starå 05/13/20Formulas and Functions

First post 05/12/20,Last post 05/13/20
Hello, Looking for some assistance with an issue we are having populating contact lists based on 2 separate sheets using a vlookup. To summarize the attachment, we have a sheet with a list of account owners and their email addresses (Clien…
Formulas and Functions161
Garrett Ricker
Contents of a Dropdown Multi Select ColumnAccepted Answer

Accepted Answer Anil Varma 25 views 8 comments 0 points Most recent by Paul Newcome 05/07/20Formulas and Functions

First post 05/02/20,Last post 05/07/20
Hi All I need help in using the contents of a Dropdown Multi Select Column. The column has the following options A B C I want to use the actual content say AB to lookup another Smartsheet for a price for that selection. I am sorry if there…
Formulas and Functions258
Anil Varma
Unparseable Error

Adrienne Buesa 26 views 1 comment 0 points Most recent by Antonio Neto 05/07/20Formulas and Functions

First post 05/07/20,Last post 05/07/20
I'm getting an error #UNPARSEABLE for the following conditional formula that sets Red, Yellow, Green, Blue symbols per combined conditions of [End Date]'s proximity to "TODAY" + Status Condition (Not Started, In Process, Complete…
Formulas and Functions261
Adrienne Buesa
Notify an assignee that the predecessor has complete his task.

Alexander Wirtz 213 views 5 comments 2 points Most recent by jwilson10533 05/07/20Formulas and Functions

First post 03/26/19,Last post 05/07/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 Functions2135
Alexander Wirtz
Counting number of new rows using Created (Date) and resetting each weekAccepted Answer

Accepted Answer Thia Davis 16 views 3 comments 0 points Most recent by Andrée Starå 05/06/20Formulas and Functions

First post 04/29/20,Last post 05/06/20
Has anyone posted a formula to use that counts the number of new rows added to a sheet based on the system generated create date? I want to do this and have it reset the count each week, perferrably each Monday. I want to: "Look in …
Formulas and Functions163
Thia Davis
VLOOKUP Doesn't Appear To Work With Auto-Number Columns/CellsQuestion

Answered - Pending Review Randy Willey 27 views 1 comment 0 points Most recent by Andrée Starå 05/01/20Formulas and Functions

First post 04/30/20,Last post 05/01/20
I have a main sheet containing a list of projects with the first column containing the ID of the project which is configured as an auto-number column. I am working on setting up another sheet to track projects tasks and want to be able to …
Formulas and Functions271
Randy Willey
Automatically Populate Monday before Existing Date in Sheet

Matt.Robinson 151 views 9 comments 0 points Most recent by KatieFields 04/30/20Formulas and Functions

First post 06/05/18,Last post 04/30/20
Hi all, I've seen similar requests on these forums but unfortunately I have not yet been able to make this work. I have a project schedule with Start Date and End Date columns. My leadership would like to see two associated columns tha…
Formulas and Functions1519
Matt.Robinson
Intake Forms: Dynamic/conditional fields or hidden links?

Tom.Richards 119 views 4 comments 0 points Most recent by Andrée Starå 04/29/20Using Smartsheet

First post 11/03/19,Last post 04/29/20
Hi! I have not found this topic discussed yet. We'd like to do a couple of things with our intake forms. 1. Make the intake fields conditional. Some surveys are set up so that what you chose in field A. will affect what you see for the fi…
Using Smartsheet1194
Tom.Richards
Conditional links on forms

[email protected] 557 views 7 comments 0 points Most recent by Andrée Starå 04/29/20Formulas and Functions

First post 05/31/19,Last post 04/29/20
Hi, New to Smartsheet, is it possible to link fields on a form based on conditions i.e: - If user selects 'Production' from the field 'Employment Department' then mandatory that must select a 'Production Shift' (i.e. one of following Gr…
Formulas and Functions5577
[email protected]
Creating custom "enterprise managed metadata" column types for use in multiple sheets?Question

Answered - Pending Review Jamie Bedford 24 views 2 comments 0 points Most recent by PPS Solutions 04/29/20Using Smartsheet

First post 04/25/20,Last post 04/29/20
Hi there, Is there a way to create a new custom column type? For example, I'd like to create a column type "Department" which would be a drop-down that would be populated with a managed list of official department names. Ideally,…
Using Smartsheet242
Jamie Bedford
Index/Match with multiple criteria - returning a dateAccepted Answer

Accepted Answer Kristina Wichmann 74 views 7 comments 0 points Most recent by Andrée Starå 04/27/20Formulas and Functions

First post 04/20/20,Last post 04/27/20
Hi, I am trying to return a date from one sheet to another based on 2 criteria that must match. I have columns COUNTRY, PROJECT TYPE and DATE on both sheets and want to return the Date from the source sheet onto the second sheet based on m…
Formulas and Functions747
Kristina Wichmann
report: take over colors in grid view of a projectQuestion

Answered - Pending Review Koen Placke 3 views 1 comment 0 points Most recent by Andrée Starå 04/23/20Using Smartsheet

First post 04/23/20,Last post 04/23/20
Hello, her's my build. I have a project file (file 1) with all details of different project but always with the same structure with different colors. Out of that I created a second PM file (file 2) with links to that main Project file (fi…
Using Smartsheet31
Koen Placke
Link Data in a Smartsheet on a Specific Day and Make StaticAccepted Answer

Accepted Answer Donna T 38 views 5 comments 0 points Most recent by Andrée Starå 04/19/20Formulas and Functions

First post 03/25/20,Last post 04/19/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 Functions385
Donna T
How to populate dropdown value list from another sheetQuestion

Answered - Pending Review Robin Soprano 167 views 3 comments 1 point Most recent by Andrée Starå 04/19/20Formulas and Functions

First post 02/05/20,Last post 04/19/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 Functions1673
Robin Soprano
How can I automate a subtractionAccepted Answer

Accepted Answer ddrame103286 16 views 16 comments 0 points Most recent by Paul Newcome 04/17/20Formulas and Functions

First post 04/17/20,Last post 04/17/20
Hey, How can I subtract a number from the total each time a row is added. I have an Inventory sheet that linked to another sheet. for example, in the picture below; how do I subtract a Number of Machine each time a row is added? Thanks i…
Formulas and Functions1616
ddrame103286
How to create a conditional formula with date specifications?Question

Answered - Pending Review Adrienne Buesa 26 views 5 comments 0 points Most recent by Paul Newcome 04/17/20Formulas and Functions

First post 04/16/20,Last post 04/17/20
How do I create a formula that counts the number of rows containing [STATUS] “Green” and have [DATE] = Today and [DATE] = Last Seven Days from Today. I do not want to capture rows that are older than seven days from today.
Formulas and Functions265
Adrienne Buesa

Ask a Question

Cell linking

Cell linking

Discussion List