-
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?
