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 DatesIn Archived 2017 PostsI 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…
-
Web Form Autopopulation via URLIn Archived 2017 PostsI 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 …
-
Link two projectsIn Archived 2017 PostsHi 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
-
Resource Management in Hours and Task RollupIn Archived 2017 PostsI 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…
-
WBS or PBS in SmartsheetIn Archived 2017 PostsHas 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…
-
Show who modified the value in a specified columnIn Archived 2017 PostsBackground 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…
-
Shortcut to Collapse / ExpandIn Archived 2017 PostsHi, 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…
-
How to Setup Formulas to Automatically Link & Pull Data from Other SheetsIn Archived 2017 PostsI'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…
-
Intermittent #blocked errorIn Archived 2017 PostsUsing 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…
-
Automatic alerts/notifications triggered when tasks are marked as completeIn Archived 2017 PostsIs 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?
