-
Duplicating projects with cell linking
We set up our each project with individual department sheets that link to other department sheets. The issue we have is each new project, we replicate the prior project, but have to redo all cell links. What I'd like to be able to do is set up a template project that can be in total so that all the new sheets link to each…
-
Cell linking
How do you get the comments to link as well?
-
Count the number of projects in a folder
Our team is looking for a way to count the number of projects of three distinct types. I have them located within three different folders. I do not want to have to use cell linking. A user should be able to create a new project without having to open a summary sheet and create a new cell link. If I could use a formula in a…
-
Cell Linking Autofill or other means when sheet too big
I sent in a comment to Customer Success that the sheet is getting slow performance. The response was bust it up into multiple sheets. Well I like the idea, I'm not sure I like the solution - it make everything now manual unless someone can tell me a better way. The first four columns in my Master Sheet would need to be on…
-
Cell Linking Limitation
I'm using cell linking for data flow through to help automate a workflow. The "Create Link" button is no longer available in the cell linking menu. I'm no where near the limitation of 5000 cell links for a destination sheet. Anyone else have this issue?
-
Dropdown lists
Hi, Is it possible to have dropdowns linked to each other. If dropdown 1 = x then dropdown 2 contains = a,b,c,d?
-
Invoke a template from a new record
Use case: I would like for a user to complete one form, and based on a value they select in the form, it logs that entry into a sheet, and also creates another sheet (a template) with a name taken from a cell in the form.
-
Relationship between the "Status" column and other columns
I'm relatively new to Smartsheet, but it seems strange that the Status column appears not to have any relationship to other columns in the project sheet. But maybe it's possible to use a formula somehow to do that? Some specific questions: * If I change a task from Not Started to In Progress, can I set up Smartsheet to…
-
Hyperlinks to other sheets not showing
Hi, anyone experienced this? I have a master sheet with a column that contains all the hyperlinks to the subsidiary sheets. The links have gone overnight! Cell history shows they were updated by a cell link user, but the cells aren't linked.... The link still exists if you double click on a cell it shows the correct link…
-
Getting value from Parent column
In the example below, I have a column named "Task Name" which contains "Version 1.0" and a column named "prefix" which contains "1.0" In the row Task A, I want to pull in the value "1.0". I was hoping to reference it by using =PARENT() Can someone show me how to do that? I have had no luck. =PARENT() provides a reference,…
