-
combining project plans and task lists
I am working on a fairly complex project plan with a large team. To keep track of miscellenous tasks, we also have a tasklist ( all in Smartsheet, of course ). The idea was that there are often many misc small tasks that dont have precise start/stop dates, categories or dependencies, and really don't belong on a project…
-
cell linking to task adjust end date
I keep linking my cell to a Friday milestone in another sheet. It adjusts my end date for the following monday, and now I no longer have an accurate date in my schedule. Instead of showing up as 1 day, it spans Sat/Sun/Mon, doesnt even include Friday. I can manually move it back to Friday but this of course breaks the…
-
Suggestions ??? - Menu with links to other sheets
I don't want to get too complicated with my design, but I would like to build a small menu in the upper left corner of my project sheets to help the PMs navigate quickly between sheets (opened and closed). The only snagged I ran into is having a menu on a report that can switch back to a sheet. I'm just adding hyperlink…
-
Row Formatting Help
For some reason my rows are not aligned. Smartsheet used to auto-correct this issue, but for some reason it is not correcting it now. I tried refreshing, logging out, etc.. Nothing changed it. Please help. Thanks.
-
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…