-
Auto-populate %complete based on dates / duration
Hi, All my project sheets are all set up with project, status, start date, end date, duration, %complete and predecessors. I also have a checkbox column to mark when a task is complete. I'd like to format my % complete column so that it auto-calculates how much of a task has been done based on the start and end dates. I'd…
-
Show Attachments of Folders
We like to see the attachments of a folder directly beside the sheets of the folder. I marked this in red in the screenshot. We think this would make it easier to find the attachments. Possible?
-
Hiding comments from external reviewers
We want to be able to send out a link to third parties and capture their feedback, but we don't neccesarilly want them to have access to our internal discussions. Since the publish settings only allow for read only or rich text (download with attachments and comments), I'm at a loss to figure out how to make it work. Can…
-
Add formula to column without changing last modified date
I would like to calculate the number of days an item has aged. We don't currently use a "closed" date field, but rely on last modified. =IF(Responsible1 = "Closed", NETDAYS(Created1, Modified1), NETDAYS(Created1, TODAY())) Is there any way to add a formula to a column without triggering the last modified system field to…
-
Default dates on web form
Hello All, I use smart sheet as project list and a web form as a work request. Our policy is that all request need to be submitted 4 weeks prior to their due date. Is there a way to have the duedate field on my webform defaut 4 weeks out from the date the form is accessed?
-
Changing the # of work hours in a day.
Should changing the hours in a day update the project schedule? For example, if the plan/scheudle is finished and based upon an 8 hour work day - shouldnt changing the work day in the project settings to 10 hours a day change the project schedule?
-
Set up notification for a complete workspace
Hi, I'm doing project management amongst multiple projects (1 project = 1 sheet) that are all in one workspace. Is there a possibility to set up a notification for the complete workspace? It's quite anoying to set up a notification to each single sheet. As I read in another discussion it's not possible to use notification…
-
Webform view, Row Guidelines
Hi, 1) Webform View- not sure if this is already available but whenever you complete a form and you ask for a copy for yourself, you get this really nice tabulated form with all the entry that goes in a single row in the smart sheet. Could there be a view ( similar to card view) that allows you to see a particular row in…
-
Customized Sheet Properties
I have a situation where our organization will be creating all of our project sheets through one group. This means that the project owners will be out of sync from who actually is the owner. In addition to this we would like to filter by certain project level items such as Implementation Status, Project Health, Escalation,…
-
I want to put the Row# to the right of a gantt bar
This should be a no brainer, which apparently I am right now...:)
