-
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…
-
If Function with Checkbox
I think this is simple formula - but can’t figure it out. I want a formula where if checkbox is checked, it puts the same amount as another extended column that I have. If checkbox 1, then take # from extended amount in same row and x1 in that cell. Does that make sense?
-
Copying Cell Linking
Is there a way to copy and paste a row and retain its cell links to the pasted row?
-
Extract location data from attachment (picture)
We are using our sheets for sidewalk repairs. An inspector in the field will open the form in the field, on his phone, fill out the basic information (type of work, address). The sheet will auto-populate the date, but I also want it to auto-populate the location. I was thinking if he were to take a photo, both android and…
