-
Sharing Multiple Sheets with a User at Once
Is it possible to share multpile sheets with a user at once? I have several sheets that I would like to make accessible to one of our users, and the only way I know of to do this currently is to go into each sheet and share one at a time. Is there a faster way to do this? Also, can I quickly view who is currently shared on…
-
Recurring task with task results stored per row
Good morning all I have created a grid for 'preventative maintenance' program - whereby the grid shows the task, owned by, frequency (daily/weekly/monthly etc), date last completed (user enters this each time they complete the task) and date next due is calculated (from the date last completed). But - my gap is that i also…
-
SMART Sheets for branch audits
Can anyone support? I want to use smart sheets for auditing several branches in our company. Has anyone done this and can share an example?
-
Workflow to create an automatic update request
Hi everyone, I have a sheet with all the projects from my site supervisors. I'm sending them a weekly update request to find out the hours worked, incidents, etc to be filled on a form. I created a workflow but it did not work properly. Not sure what I'm doing wrong. Any help would be appreciated. P.S. See attached picture…
-
How to stop due date reminders once task has been completed
HI- We use Smartsheet for tasks that need to be completed by several people. We currenlty have reminders set up for due dates (both 5 days before due date and past due date). Is there a way to NOT send the reminder if the task has been completed/the 'Date Completed' field has a date in it?
-
Best method to update a project sheet
Hello everyone! I'm a project coordinator at a company specialized in manufacturing and installing irrigation systems, we have over 50 projects going on at the same time. We're trying Smartsheet to check whether it suits our needs, we're looking for a way to let a user supervising the project to update the progress…
-
WBS numbering and work arounds
Good afternoon Smartsheeters ;) I am only new to Smartsheet and have started working on some existing docs. We have a very clunky and manual way of applying a designated PRIORITY number. When the sheet for each project/group of projects is first started, its easy - everything is labelled from 1,2,3,4,etc til the last row.…
-
Predecessor formula
help me please I want to see in our project through a filter in which I specify: 1) If the status is not fulfilled 2) Deadline date in the past This is all I can do, but through the filter I need 3 points 3) All tasks that have a predecessor with a task number (which is not completed and overdue by date) This should all be…
-
Data accuracy
I am working on a way to verify if data in all my sheets (about 10) is accurate, however, the trouble I am running into is the data is frequently updated. Is there a way to run a report that is like activity log within each sheet? Thanks, Amy
-
Smartsheet reporting and dashboard
Hi, Attached below is a screenshot of a Smartsheet dashboard that we have had set up on our project by someone else. The dashboard data is being driven by a report which is in turn being driven by a stats sheet (screenshots also attached below). I have a couple of questions in relation to setting up a different dashboard…