-
Data Mesh & Automated Sheet
I have a reference sheet that is connected to a more widely shared "Active Projects" sheet via data mesh. The reference sheet was created to be able to edit rows of the same project type in one sheet rather than dig through all active projects to make updates. The "Active Projects" sheet has an automation to be added to a…
-
Rows could not be added to the destination sheet because it did not have enough cells remaining
I have a blank sheet that serves as a "backup" for our main sheet. We have an automation that copies the data from the source sheet to the to the backup sheet once a week. To work around the fact that smartsheet doesn't have a built in way to delete data, we also have a blank excel file that "uploads" to the backup sheet…
-
PI Planning (PI Board)
Hi, Has anyone ever use smartsheet to run PI planning? I like to use it to create PI board where you can track feature releases, dependencies..etc. Is there a template or a way to configure it?
-
Timeline View (Reports)
Hi, Is there a plan to provide the option to manually re-order the swim lanes in timeline view? I am using a report that pulls from several sheets and it would be helpful to have this option without creating helper columns in each of the source sheet to do so. Additionally it would be helpful to have the "fields shown"…
-
Allow Mandatory (Required) Fields in Update Requests Triggered by Automation
Currently, when using Automation to send Update Requests, there is no way to enforce mandatory (required) fields for users completing the request. This creates data quality issues, as users can submit incomplete updates, even when certain fields are critical. Proposed Enhancement Add the ability to mark specific fields as…
-
RACI Template
Is there a RACI template that Smartsheets already has or does anyone have any suggestions?
-
Status to red once the deadline is reached.
Hi everyone, I’m trying to automatically change the Status to red once the deadline is reached. I placed the following formula directly in the Status column: =IF([Ende]@row <= TODAY(), "Red", [Status]@row ) However, I keep getting the error #CIRCULAR REFERENCE. My understanding is that this happens because the formula is…
-
Sending a Notification not Working
I am still new to Smartsheet and I am trying to add automation to send a notification to a email account but it is not working. I have no restrictions on the project . Can someone help.
-
Showing a timeline (not programme) in a Dashboard
How do I show a timeline as a widget on the dashboard, not the programme breakdown with multiple rows. I am looking to represent a single row that represents the flow from one activity to the next so you can glance at it and see where we are and what's next. Thanks
-
Global/Regional Holidays feature
Dear Smartsheet Product Team, We would like to request enhancement to Resource Management (RM) to improve its functionality for global teams: Country-Specific Holidays Currently, any holiday added in RM applies to all resources company-wide, with no option to assign holidays to specific countries or groups. This limitation…
-
Tasks with multiple start and completed stages before FINAL completion
Hello! I'm building a sheet to track multiple tasks. Each task (FILE) has different stages of completion (PROCESS/INTAKE, Research, Drafting, Reviewing and Finalizing). Each stage has an ASSIGNED TO contact and COMPLETED date. The Finalizing date will be the FINAL/END date. We want to track turnaround time per ASSIGNED TO…
-
Reminder Automation
Hello everyone, I need help in this!!! I’m trying to set up an automation where a reminder is sent to the contact list 1–2 hours after a row is added to the sheet. Is this possible in Smartsheet? If so, could someone please help me with the setup? Thanks
-
How are you scaling a PMO in Smartsheet across multiple departments/workspaces?
Hello everyone! We have a great structure within our own department and looking to expand across our firm. I am looking for insights on how you manage cross‑department projects when each department has its own workspace? Interested in workspace structure and reporting best practices. I appreciate the help.
-
Clock In and Out with Lunch Time Stamps
I need help creating a formula that will calculate my employees time in and out along with their lunch break.
-
Tracking a 1-day project based on time not date
I am helping manage a 1-day Disaster Recovery exercise and we want to track the tasks by start & end based on time of day. Would also like to auto adjust the times with dependencies - Does anyone know if a template is available of has anyone ever done this before?
-
Additional API endpoint for exporting Dashboards
Hi, I was wondering if there could be an API endpoint to export dashboards from smartsheet. Would be a reliable solution for the automation I am trying to create. It would be similar to going to a dashboard→clicking on file→ print.
-
Add Stacked Area Chart type to Dashboards
Please add the Stacked Area chart type to Dashboards (available in Excel)
-
Selecting the best Smartsheet for your project
I need to make sure I am selecting the correct smartsheet workspace for my project. I am trying to create a workspace to track and share client implementation. How do I add a Start date and then the sheet automatically adds task dates, as well as deadline, completion percent dates without having to add all manually. I seem…
-
Start and End Date in RM in Projects
Im not able to figure out how to sync the start date and end to actual project plan. Currently the dates showing in RM are from Intake Sheet which is the Target Start and Target End Date which are estimated dates. This is entered initially when filling out the NPD form to start the request of a project. Once the project is…
-
Predecessor #REF Error
a PM asked me to look at his schedule because one of his predecessor cells had #REF. We can't figure out why this is happening because he references line 176 in other cells in the column. When I went and looked at the schedule on my computer, the #REF error moved to a totally different cell and I don't see it in the same…