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.
One task split into multiple periods
Hi Smartsheet! I have used Smartsheet at my former job and have now recently switched job and am evaluating what PM tool to use within the new company. The overall experience from working with Smartsheet has been positive but the tool however has one very critical shortcoming as I see it (at least for how we wanted to use…
Can you create a filtered version of a smartsheet without having to link each link one by one?
I'm trying to create a live copy of sheet1 so I can filter and share with execs. I know I can link sheets but I don't want to do that every time a new tark is added. Is there a way to create a copy, add filters and have it updated as soon as I add new tasks?
Row changes that don't affect Modified Date field
I see in your help documentation that changes to discussions and attachments do not affect the Modified Date type of System Column. Is there a reason for this? If a week-long discussion takes place within the discussion feature of a row, the Modified Date element makes it seem at first glance as if the toipic has not been…
Sending emails via Outlook from Smartsheet
Either I'm being dense or this is actually impossible, but I thought I'd ask. What my staff member wants is for the email addresses he puts into cells in Smartsheet to become essentially live mailto links (just what happens in Excel: put in an email address, it will convert it to a link that will automatically open Outlook…
Smartsheet formula syntax help
I am trying to write a formula to add 9 months to date from another cell in my worksheet and am struggling with the formula syntax. Adding days to a date is very straightforward, but I have not been able to figure out how to identify how to add months to a date. Can anyone help with this formula? Thanks, John
Is there an Automatic Save feature for sheets?
Is there a feature to have sheets automatically save? My group and I have found it very troublesome and inconvenient when we lose valuable work due to the browser closing or changing tabs on active sheets. It's nice that the sheet notifies us that we have not saved, but sometimes that could be overlooked if you're moving…
Creating Web forms with Auto-populated form content
I see that you can auto populate a section of the form by manually entering (post-URL): &ColumnName=text where any spaces in the text are replaces with %20. Question: I first used the substitute function to replace %20 for all spaces in a column that contains the desired text. But am unable to have the sheet pull that…
Is there a reasonably easy way to track earned vs planned value with Smartsheet?
Status Symbols (traffic lights)
Hi - Can we have set with 5 traffic lights. There is currently four and we use them to represent on-track (green), at risk (orange), overdue (red) and complete (blue). We feel we are missing one to indicate 'not started'. You already have a grey traffic light but it is in another set of four and it would be very helpful if…
In excel you can have multiple worksheets in one document. How does this work in smartsheet?
In excel you can set up multiple tabs or worksheets in one document. How can I best do this using smartsheet? Any tips? I have a excel sheet from finance using multiple worksheets and staff names, project codes and formulas for high level tracking of time against multiple strands of work. I would like them to use…