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 2017 Posts

Archives for June 2017

Discussion List

  • Back Tracking Dates
    In Archived 2017 Posts
    I am trying to create a formula that can generate a date 2 weeks prior to a set date. For example:  9/1/17 - 14 days = 8/18/17 I assumed the formula would be as simple as "=[cell w/ given date] - 14" but it will not work and th…
    17 3
    Closed 17 views 3 comments Most recent by J. Craig Williams Archived 2017 Posts
  • Web Form Autopopulation via URL
    In Archived 2017 Posts
    I am having problems with creating new URLs to auto-populate web forms. All of my old ones still work, and the regular web form functions still work, but I get an error stating the form is no longer active when I try to add information to …
    62 9
    Closed 62 views 9 comments Most recent by Kara Lumley Archived 2017 Posts
  • Link two projects
    In Archived 2017 Posts
    Hi everyone, I have question that I have two different projects can I link them? Can I able to set Predecessor from one project to other? Thanks, Pranav
    13 1
    Closed 13 views 1 comment Most recent by Richard Rymill SBP Archived 2017 Posts
  • Resource Management in Hours and Task Rollup
    In Archived 2017 Posts
    I recently started using the Resource Management tool and I have two questions about it.  We are using 1 sheet only. 1)  Is there a way to display hours vs. percent allocation?  Everything I have seen with this feature thus far seems base…
    401 5
    Closed 401 views 5 comments Most recent by [email protected] Archived 2017 Posts
  • WBS or PBS in Smartsheet
    In Archived 2017 Posts
    Has there been any further discussion on implementing this?  If I create the hierarchy in a sheet, when i switch to card view, it is not giving me the view of all the "cards" that report to each parent; rather it is sorting by s…
    21 1
    Closed 21 views 1 comment Most recent by Mike Wilday Archived 2017 Posts
  • Show who modified the value in a specified column
    In Archived 2017 Posts
    Background We create and approve purchase orders via Smartsheet. On receipt of the invoice to the accounts team the named approver (Contact List column) for the PO is sent an update request with the attached invoice and the field "in…
    197 1
    Closed 197 views 1 comment Most recent by ricki Archived 2017 Posts
  • Shortcut to Collapse / Expand
    In Archived 2017 Posts
    Hi, It would be very useful to have a shortcut to Collapse / Expand grouped lines, instead of clicking on the little +/- buttons. When using a lot of grouped lines it becomes really tedious to always look for these tiny buttons. Is such…
    2553 13
    Closed 2.6K views 13 comments Most recent by JBudd Archived 2017 Posts
  • How to Setup Formulas to Automatically Link & Pull Data from Other Sheets
    In Archived 2017 Posts
    I'd like to try and figure out how to most effectively and efficiently connect 2 separate smartsheets together, preferably through some sort of smart formula/code. I don't think doing a manual "cell linking" from a cell in one sh…
    371 2
    Closed 371 views 2 comments Most recent by Mike Wilday Archived 2017 Posts
  • Intermittent #blocked error
    In Archived 2017 Posts
    Using the formula below in combination with predecessors (FS -5d) I get an intermittent #blocked error. Sometimes when I make a change (add a date / change predecessor) it goes away. I can make a change, undo the change, and the error is g…
    97 1
    Closed 97 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
  • Automatic alerts/notifications triggered when tasks are marked as complete
    In Archived 2017 Posts
    Is there a way to have alerts be sent out automatically notifying the next team member that a dependency they were waiting on is now done based on tasks being marked as complete?
    64 1
    Closed 64 views 1 comment Most recent by Mike Wilday Archived 2017 Posts