-
Is there a way to assign a certain task/activity to multiple groups and generate report by group?
I want to use Smartsheet to track progress of task/activity by team or people. However, some tasks/activities may be assigned to multiple teams or people. For example, activity A to be done by x & y. Activity B to be done by y. Then, I want to create a report/dashboard to show all activities assigned to y (activity A & B),…
-
Creating a Report that ONLY shows rows with Attachments
Is there a way to filter out rows that show up in my report that do not have attachments? I'm building a report that shows my subcontractors any row that's had an attachment added to it in the last 7 days, but I can't seem to find a way to get the Report Builder to only show rows with attachments added. I realize I could…
-
Recurring Reminders for the same Row/Action
Hello, I have a row/action that I would like to set an automated weekly reminder. I currently go in weekly to manually put in the reminder. Is there a way to automate this so I get a reminder on this task every Monday (at 2PM)? Michelle Rojas
-
Stacked Bar Chart
I am attempting to create a bar chart widget that summaries hours by department on a given project, but I can't seem to figure out how to get it to display the information I need it to. I have the data set up in a sheet as follows: I would like the graph to show each department's hours as a portion/percentage of the total…
-
Workflow Question - Decline with An Attachment
Wondering if anybody encountered the same situation here. I have a very simple mechanical drawing approval workflow that works fine if the approver only click on "Approve" or "Decline" button. The approval column will change to Submitted when drawing submitted (trigger by attachment), and changed to Approved or…
-
COUNTIFS from multi-select drop down
Hi Community, hope you are well! I would really appreciate some help with the following formula. In a master metric sheet I would like to count multiple criteria. I am using this formula which works great since it is automated once the @row are filled in by my Team: =COUNTIFS({Planning sheet Range 2}, PA@row, {Planning…
-
Version Control of Project Plans/Sheets?
Hello, I am wondering if there is a way in Smartsheet to version control the sheets. Basically, we are using each sheet as an individual project plan. However, as projects progress, the plan will (usually) slip and/or have to be updated, so we need to amend it. Since there seems to be no way in Smartsheet to baseline the…
-
Has anyone attended the Project Management Track from the Learning Center
Are they worth the price tag? can I get this info watching Youtube videos for free?
-
Designate Holidays for Multiple Years
Hello, I am wondering if there is a way to automate/semi-automate adding holidays to project settings. For example, is there a way to indicate 12/25 will be a holiday regardless of the year, so that as time goes on new Sheets will always take into account standard holidays? Thank you, Dan
-
Index Match Formula with Multiple Criteria?
Hello, I'm trying to create an index that has multiple criteria. I'm not sure if I should do this using an "IF" formula, or if I need to incorporate the "AND" function into the formula. Or if I need to go in another direction to accomplish this. What I need to do is return the "Rate" based on the "Crew Type", and the…