Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2015 Posts
Archives for April 2015
Discussion List
link to another cell
It is possible to have two differents sheets, but once you update one of them in some cells the other sheet updates automatically????
Sheet Size
I have sheets that vary in size but most lean to the larger size due to the amount of formulas in the sheet. I am looking to see if on average people are choosing to have more sheets and less size or less sheets and fill the sheets to the top. I have done alot of work to all of my sheets and some have had to be divided. If…
Monitoring project activity
Has anyone got tips for quick ways to see who last updated a project and when it was last modified? I'd like to be able to quickly identify which projects have not been visited by their project lead for a given period of time so I can report this to exec sponsors. The home tab shows when a sheet was last updated, but not…
Suggestion for dynamic lists
A feature that would be fantastic for large scale project work would be dynamic lists that could be set up on a sheet and then referred to by drop-down lists in other forms/sheets. E.g. As more projects or names are added to a sheet these then automatically populate drop-down lists for an "Add new risk" form.
Microsoft Project Import
Hi All, I use smartsheets mostly as a project management system for my clientbase. Most of my clients reuiqre porject schedules to be in Microsoft porject and I prefer doing my plans in MSP as it has much more funcatonality in terms of cost tracking, rsource planning etc. I import project plans from MSP into smartsheet and…
Suggestion for update requests
It would be really useful if the text, timing and recurrence of update requests could be amended after setting them up. This would allow the requests to be a more substantial and reliable tool for on-going communication with project leads. I quite often have relatively lengthy instructions/guidance attached to the requests…
Tip for Day to get the team to play.
One of the things that we have done as of late to speed the ability to work in the sheet and for people to move about in the sheet is hyperlink your sub sheets to your master sheet. The Hyperlink creates a fast way to go to anothe sheet without closing the main sheet. If you have you settings correct you can have a new tab…
cell linking and formulas
I am currently working on a Dashboard sheet.. that i would like to count the number of each status within the first sheet. For Example Sheet 1 - contains 150 rows of data with different stages of Status Sheet 2 - Would like to create a formual that would go back to Sheet 1 and count a specific status and advise the count.…
How can I conditionally update a cell but leave the current value there if the condition fails?
I keep track of about 40 active projects in our company. Among other things, I keep one Smartsheet on each project that shows the hours worked by several different functional areas on a week-by-week basis. I only want to put the current week's hours into the project history row for the current week after they have been…
Is it possible to restrict Check Box Columns to specific user or account types?
I am trying to create check boxes on a shared sheet that only I can check as approved, is this possible?
