-
Trouble with understanding Workflow
I work for a company that runs clinical trials; I want to create a way to send out vendor performance surveys to Clinical Trial Managers (CTMs) who work with the vendors on different studies. Each CTM is responsible for one or more studies, and some vendors are repeated in different studies. The CTM needs to take a survey…
-
Grid/Report Linked Cell Issue
I have a Grid I was setting up a Data Shuttle on. This Grid had one cell that was linked to a Report. After a Data Shuttle pull, the cell in the Grid that linked out was missing the previous formula and not showing the "link" symbol on the linked cell. I re-entered the formula in that cell, however when I went to the…
-
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…