-
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…
-
The Power of the SUMIFS Function
When I discovered the SUMIFS statement recently it solved a problem that had made me keep things like the project timesheets for our company in a very rigid format that basically listed all projects and functions (types of work) that could be charged to. I had wanted to let people select the project they were working on…
-
Create time card from project schedules
Is there a template out ther somewhere to take all projects shared to an individual and create a weekly report (timecard) showing the number of hours that indiviual is scheduled to work on each project? It seems like most of this is available in Resource manager but I'd like to have it report hours versus % allocation.
