-
Date Formula
Hi I am trying to calculate a date formula but having not luck! I am wanting a main date in my sheet, to trigger dates in other parts of the sheet but cant seem to find a formula which works. I also need to add days into the formula; eg. Project Start Date + 30 days Can someone help please, unsure where I'm going wrong.…
-
"Modified / Modified by" fields
I noticed that when I save a shared sheet, the columns "modified" and "modified by" change to my login and the time stamp when I saved for ALL rown in the sheet. Is it how those column types are supposed to work? In the help contents, I read that those columns change ONLY in the ROW where data has been changed. It doesn't…
-
Enable and Set Up Auto Logout
Is it possible to set Smartsheet up to automatically log off users due to a period of inactivity?
-
Formatting for Project Lists - suggestion
I was hoping there was some formatting option so that when I set a status to complete (either green orb, full circle etc.) that there would be a way for that row to automatically be moved to the top of the sheet. That way the "in progress" and "completed" tasks/projects could be better organized. Just an idea. Thanks
-
Duration minus Actual Effort
We would like to be able to track actual vs estimated duration, as well as the variance. ie: Duration Column 4 days, actual work 2 days, variance -2. Duration Column 4 days, actual work 6 days, variance 2. And be able to roll the totals up at the top of each parent task. If a task is scheduled to take 90 minutes, but we…
-
Sending Attachments
I want to send/share a row with someone and I want them to be able to see the images in the attachments without having to open them. For instance, I need to send a General Contractor a Weekly Report of work completed. There are attached images on a row that need to be sent to him. I could share the row, but it would not…
-
Email Notification - How robust is it?
We like the email notification feature, but one of our engineer who has a good Network/Internet knowledge has raised a concern about this. He claims that at this very moment, it looks fine. The email path (sorry for my childish words..) is directly connected to Google and there is no ISP in between, but there is no…
-
Adding Workdays to a Formula
Hi SmartPeople - I am trying to create a formula that adds "work days" to a date. Example: I have a "Date Reported" column and a "Date Due" column. The "Date Due" column is a formula based column that should add a specific number of days (either 5, 10, or 20) based on a given priority in the "Priority" column. However,…
-
Create a live copy of my sheet
I would like to be able to re-order my sheet without the parenting hierarchy in place. I was thinking that if I create a live copy that is always up to date but does not have the parenting information this would be easy. Basically, I have task assignments under projects. and different people are assigned to different tasks…
-
Resource utilization across projects
Is there a way to see the TASKS a resource is assigned to, across projects? The Resource View only shows which projects and overall Allocation %, I want to see the specific tasks. Thanks!