-
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.
-
PM Training
Smartsheet is great, but requires some basic knowledge in project planning, deliverables, milestones and dependencies. This is not the full PMP training...that's way more than necessary to use Smartsheet. Does anyone know of any good online (or even webinar) training that I could get to my team to learn these basics?
-
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…
-
Subcontractor needs help
I'm brand new to smartsheet and I'm trying to figure out how to best structure my sheets for managing multiple projects. We're a construction subcontractor with 50-60 different projects in process at any given time - new ones added nearly everyday and other completed projects dropping off. Do I need to set up a separate…
-
If N/A checkbox is marked note % complete as 100%?
I have a "Not Applicable" and a "% Complete" column. I would like to create a formula that will automatically set the % complete to 100% if the Not Applicable checkbox is marked. Any suggestions? Thank you!
-
Dependencies by Assigned User
Can dependencies by automatically set by Assigned User? i.e. Fred has 5 tasks each will will take a day - can the start and end date be automatically set with dependancies?
-
Assigning Colors to Contacts
I use the gantt charts and calendars to make sure my contractors are not in two places at once. Is there a way to color code each contractor so when I assign a task, it automatically shows in gantt and calendar view as the color assigned to them? I seem to have to do it to each individual task. Then the color coding doesnt…
-
Downloading attachments through API with URLs fails
When requesting to download an object, I get a "timing limited" URL of the form: https://s3.amazonaws.com/SmartsheetB1/*******?response-content-disposition=attachment;filename="*************************.pdf";filename*=UTF-8''*************************.pdf&Signature=*********=&Expires=********&AWSAccessKeyId=***************…
-
Automatically add tasks to a web form populated row
Hi, I am fairly new to smartsheet and wanted to know if it was possible to automatically add a set list of tasks/ indented rows to a row that had been added via web form? I review sets of data that are submitted by multiple business unit and partner companies. The form this takes in always the same, and we have a set…
