-
Dependency between multiple RYGG cells
Hi, Is it possible to create a complex dependency such that a task's status is derived from it's sub-tasks' status. i.e: Status Task AVG(ST1-4) ST1 R ST2 G ST3 G ST4 Y That way we could avoid manually updating task's status manually and also connect it between sheets. Thanks
-
Track Delivery by Time
Is tracking delivery a part of your enhancement plan? In construction, we work with many subs that would deliver to the job site every 15 min. Being able to specify and track time would also help procurement. If this is already in the app, please provide direction. Thanks
-
Report based calculations
I would like to be able to have a calculation take place in a report that is based on numbers in cells from two different spreadsheets. Any ideas? Not keen on linking for this application as that would require multiple linking of new data, which would have a higher probability of user error.
-
Update Request / Send Row From Within A Report
We leverage reports to an extremely high degree to avoid data losses in a massive sheet we use company-wide. One of the things we would really love to be able to do is send a row, and send an update request from within a report. This would save us time, and keep our users off of the main sheet, which is always a good…
-
Editing attachments in Office 365
We are hoping to roll out Office 365 in a few months (maybe longer). I'm wondering if that allows the editing of documents as links or attachments in Smartsheet (we're not able to use Google or the other listed options at this time). Blessings, Loann
-
Method for planning repeated tasks?
Hi there, I'm wondering whether there is a current method - or planned feature - that will enable users to easily create recurring tasks? I envision this either occuring as multiple dates within a single task (preferably) or by having a seperate line for each date of said task with the start date automatically occuring at…
-
Date Formula Help
Can someone share with me the work around they are using for the following issue? Example Start Date 08/01/14 Time I want to add to this date - 14 months Fomula I want to use =DATE(year(08/01/14),month(08/01/14) + 14, day(08/01/14)) Which returns an error because the month value is > 12. In excel it just adds 14 months…
-
Update start date with report
Hi all a quick question from a relative newbie: I am setting up a project sheet and want to be able to issue report updates to our outside contractors on a project. I am struggling with a feature in smartsheet. I would like to have my engineering firm provide a start date on a task with a dependency without having to…
-
Column Properties
Hi Community! Is it possible to only allow for a single type of text in column cells and not any other type? For example, if I choose the column property as a date, can the cell restirct the text in the cell to only allow for dates? This is done in Excel using data validation. Please help! Thanks, Dave
-
Gantt & Calendar Views on Reports
Thank you Smartsheet for the new feature allowing Gantt & Calendar Views on Reports! Best thing since sliced bread and dental floss!
