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.
Discussion List
linking existing discussion to task
I just got started with Smartview and created a few discussions. Then I wanted to link those to a task. Can't quite figure out how to do that. Later, I found out I could create a discussion from the task line which will then show up in the list of discussions..... Also, what is the order in which discussions are listed?…
Publishing a Calendar to Google
I have published calendars to google several times by going to calendar mode in SS and selecting the "Publish to Google Calendar" button then selecting "ON" and it shows up on Google under "My Calendars" . But my problem is that one employee is trying to publish a calendar to Google but it will not show up as one of their…
Limited view of sheets to external users
Does anyone use SS to ascertain details from team members using webforms but then build that out on the backend? If so, how do you then display only the information you want to team members back out? Ideally, I would like SS to construct a query interface or limited viewing of sheets for external users. It appears to me…
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 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…
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…
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?
Formula question
Hi Smartsheet community! I realize there is a help area for this but I have looked ... read.. googled.. till I'm blue. So this is new and I thought in this NEW COMMUNITY maybe I could shout out for some help. I am trying to do a formula so that the smartsheet can look at a month ( column ) and then determine in another (…
How can I archive sheets that I no longer use?
My team has a bunch of sheets that we do not use but we might need to reference later. Whats the best method for archiving sheets we are not using so they do not clutter up our accounts or count towards our sheet count but with the ability to access them as needed?
