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 November 2015
Discussion List
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…
Nesting Formulas
I need some help with nesting formulas for the following screenshot: What I'm trying to accomplish is an automatic change in the "Status" Column based on the following criterias: 1) If "%Complete" >= 1% and "%Complete" <= 99% and "At Risk" = 0 then "Status" = In Progress 2) If "%Complete" >= 1% and "%Complete" <= 99% and…
Copy a set of sheet that have links
I have created a set of sheets that I will use to managed various parts of a Project. Between the sheets, I've linked a number of cells, pulling data from one sheet to another. As I'm going to run this type of project many times, I need to copy this set and reuse them for another project. I can copy the sheets, but the…
Font name/size not retained
I changed the font name and size on my entire sheet to make it more readable, making it Tahoma 8pt. Today I updated a percentage complete field and found it entered in Arial 10 point. Looks like a bug to me. Anyone else getting this?
Problems wrapping text?
Has anyone had a problem wrapping text? I've had a few instances where text needed wrapped in a cell, but the wrap command was not working.
Rich version of Reports in iFrame
I want to display via iframe on my website a report returning only certain information. This information should be able to be slightly manifpulated from the report view, by visitors to the website. For instance: 1. I have 1 main sheet with all the columns and rows of information possible, but I don't want all of that…
Resource allocation by project, not by person
Hi, i like the resource allocation views but in addition to knowing what people are working on, I'd like to see what we are using our resources on by project. so rather than seeing that Sue is allocated 50% to project A and 50% to project B, I'd like to see a list of all of our projects and how many of our resources we are…
applying vacation or unavailable time to resources
Hello, I am an MS project user and in that program you could denote unavailable time for resources so when a task assigned to that person fell on an unavailable time period, the start and end dates accomodated for that automatically. Is there a way to do that in SS? thank you, Karen
Send Update Request - Need more time
Is there a way to give the contact more time to fill out a Send Update Request? The request is timing out before they submit their update.
Update Request to Contact List
As administrator I would like to setup update request weekly to assigned contacts (responsible parties) from a contact list. Is this functionality available? Thank you, Jay