-
Merged: Dynamic Column Linking
This discussion has been merged.
-
How to get the same name from two different sheets to populate a third cell based off their response
I have a sheet (Sheet 1) that is being populated with a person's information after they fill out a form. Smartsheet then sends out an email to that person through a workflow to follow-up with them. The email contains a smartsheet form that allows the person to put their name and follow-up answer. This is populating Sheet…
-
How can I create a helper sheet that reads totals from multiple reports
I need to create a 'helper sheet' sort of like a metrics that will collect multiple counts from multiple reports so that I can chart it easier in my dashboard. I currently have 60 reports which each have 3 counts on them, meaning that each one would need to be charted individually. I would like to be able to create a…
-
dynamic reference/dynamic linking from another sheet
I want to link a cell from sheet B to sheet A, where the column name in sheet B is determined by a string in sheet A. i.e. "sheetA_string" is dynamic, and matches a column header in sheet B. Datamesh does not allow dynamic column linkages. (this would be ideal). I'm currently using index( match( {find row} ), match( {find…
-
Is it possible to dynamically reference Sheets from a cell value?
Hey, hoping it might be possible to get a little help here as the search feature just gives me 1000 permutations of 'link to the other sheet.' What I'd like to be able to do is link to a sheet named in a particular cell. So if Column 2 Row 1 says 'First sheet' and Column 2 Row 2 says 'Second sheet', I'd like the same…
-
Enhanced Field Linking - Editable Both Ways
Add the fucntionality to link fields, however have these fields editable in either sheet. This can be added as a toggle when linking fields, and will allow the editing of fields directly from the summary sheets, rather than needing to navigate to the back end data.
-
When I Copy Workspace, Everything Copies Fine Except for CellLinking
Hi, Using the API documentation, I'm able to copy entire workspaces which has been great for scalability. I've been noticing that the only thing that doesn't work correctly out of all the sheets, reports, and sights, is the cellLinks in my sheet. In the instructions, you can tell it all the different things to pull in. I'm…
-
Cell values automatically reverting to previous values. Changes won't save.
I have a very serious concern. I am updating the contacts column to change the contact from Richard to Teresa. However, after about 10-15 minutes Smartsheet automatically reverts to the original contact. This has been happening for a week . I am very concerned because how can I be assured that changes are saved in all my…
-
Automatically linking cells when a new row is added to a sheet
I have two sheets. Sheet 1 contains primary data, the other secondary. When a new row is added to sheet 1 I want to be to create a new row in sheet 2 that contains the information in specific cells from sheet 1. I want that link to work such that if Sheet 1 is updated that is reflected in sheet 2 - the sheets stay in sync…
-
Collaboration with multiple sheets and a single, "external" user.
Hello, We've built an environment for our budget process that has a dedicated Smartsheet for our various regions, each of which has a dedicated Dynamic View. This allows our HR team to work collaboratively with our Finance team. The HR team has access to the underlying sheet while finance has access to the Dynamic View. We…