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
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 the column is a Date Type. Any suggestions?
Web Form Autopopulation via URL
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 the end of the URL. Is anyone else having this error?I am 100% sure my formula is…
Link two projects
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
Resource Management in Hours and Task Rollup
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 based on the latter and I'd like the option to report on the former 2) Is there a way to…
WBS or PBS in Smartsheet
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 status or assigned to. Any suggestions on how I can work around the system and implement something…
Show who modified the value in a specified column
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 "invoice approved". They review and check the box, submitting the update. There are 12 invoice…
Shortcut to Collapse / Expand
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 a shortcut planned? Regards, Xavier
How to Setup Formulas to Automatically Link & Pull Data from Other Sheets
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 sheet to the next would be very smart or efficient for what I'm trying to do here. I have both a…
Intermittent #blocked error
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 gone. What am I missing? =IF(COUNTIF(CHILDREN(), "Red") > 0, "Red",…
Automatic alerts/notifications triggered when tasks are marked as complete
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?