-
Combine 2 or 3 cells into one?
I have a webform that collects data for a request, Department, Type, Etc. These are separate columns. I would like to somehow filter the some of the information received into one column, which would then be a code for that particular request. The code is then used in other locations as an identifier. Is there any way to do…
-
Linking Sheets
Thought I will just share this with everyone to show how powerful smartsheet is. I have just set up a medium sized project where I will have 3 different teams running their respective phases across numerous sites. Each team needs to know the status of the other teams work in order to schedule their own work From their…
-
Is there a way to build a template containing multiple sheets
What I'm trying to do (maybe there is a better way) is to build a project template with contains the project sheet, a requirements sheet, and a budget sheet. When we "use" the template, it then creates all three sheets. Similar to the "Solutions" on the Smartsheet website. Thanks in advance for any help.
-
help - with formula/cell linking across multiple sheets automatically, without having to manually ad
Summary: I have loads of sheets in a "project" folder, 1 for each project, which have identical layout (column names etc). Each sheets has a region field, which is either UK, China, Japan, HK or Multi. I then have reports which take the relevant information I need from all sheets in the "report" folder, which is then…
-
Using smartsheet for grant writing
I am a grant writer at a nonprofit and my development team uses smartsheet. I am at the beginning stages of using smartsheet and want to use it for EVERYTHING related to my grant writing (calendar, deadline tracker/notifier, links to emails, links to webpages, task list, grant applications, anything else you can think…
-
Lock source links
I've created a web form that feeds a very simple tracking sheet. Each week, the person providing the info will submit their data via web form and the information flows to row one of the tracking document. In a separate sheet, I've created a dashboard that should, in theory, pull the latest data and compare it against…
-
Anonymous sharing to users without publishing
I'm looking for a workaround for a problem with sharing a sheet and its attachments with several non-licensed users. The situation is that whilst the collaboration features in Smartsheet are great when we are working within our team, they are problematic when it comes to sharing the information. We need to give several new…
-
Columns
I would like to be able to link columns from one sheet to another. Thank You
-
Conditional formatting on linked date cells
Hi, I have created a sheet with linked date cells from another sheet but have found that the conditional test 'in the past' does not seem to work in the linked cells. I assume this is a current limitation or has anyone got any ideas to resolve this? Thanks Jacky
-
Can a cell be linked to multiple rows simultaneously?
Hi, I want to link a cell value to multiple rows of another sheet. I tried copying the source cell, highlighting multiple cells in another sheet and tried Paste special - Link to copied cell. However it only assigns the value and links to the first cell alone !! Any help or direction is highly appreciated.
