-
Formatting Capabilities in Automation Emails
I love the automation opportunities with Smartsheet, but as I have seen some previous commentary/questions about being able to actually format how the emails look more would be a HUGE help. Some of these we would like to go to various leaders and without being able to customize more or even build a more corporate style…
-
Project Plan - Start/End Dates, % Complete and Duration columns not updating.
Happy Friday! Appreciate your feedback, please! Here's a pic from my Project plan (created from the PMO Template) showing the column titles and rows 1-6. Rows 3-6 are in the first phase of the project (under row 2, grey). These are the only completed tasks out of 39 for the entire project. the rest are not started. I'm…
-
Record the time when specified criteria are met
Hello, I'm new to Smartsheet and I want to set up a workflow that records the date and time automatically when a previous column's value is changed to "Yes". I know there's a template for recording a date when specified criteria are met, but I couldn't edit it/find one to automatically record time. I see that there was a…
-
Project Status Report > Horizontal View
In our team project trackers, we are leveraging worksheets with grandparent/parent/child relationships to organize by the the different business/clients/projects. Our desired automated reporting output is to transpose most of what is captured in a row format into a column to enable a snapshot view that is horizontal in…
-
Copying Data from Locked Cell as Editor
My team is looking to lock a cell so that only admin's and owners can edit the column, but we need our other team members with Editor permissions to be able to at least copy and paste the cell and have the data move with it to a new row. Currently, an Editor cannot copy the cell and paste and have the data show up in the…
-
Shortcut & Hyperlink accessible to Non Smartsheet users
Creating Dashboard, Sheet to centralized all links to other sheet in a Workspace. I need non Smartsheet user to easily navigate from sheet to sheet to collect data from them. My tasks: Creating Workspace out of a template. Publish sheet Insert hyperlink to freshly created sheet/Dashboard Share Master sheet to non…
-
Stop Predecessors from being deleted when a date is deleted
Sometimes we need to just delete the dates to start fresh or copy rows to use for another project, but deleting the dates also deletes the predecessors. I was trying to test a schedule template with many hours of work on defining the predecessors. When I wanted to blank out the dates again so it could be used as a blank…
-
Recurring Tasks
Hello I am setting up a smartsheet that will be used to track all the recurring task we have to do in a year. The frequency at which these repeat vary drastically so I wanted to see how one would format their sheet to account for this. For example I have a task that needs to be done the Monday following all major holidays…
-
Changing / Moving Existing Profile Data - Intake Sheet to Project Sheet
Hi!! We have a large program & want to change where some of our Profile Data fields are being entered without breaking things / renaming fields / doing a ton of avoidable repairs. I'd love some advice on common issues / the best approach! ------- Program Setup (for reference if needed, feel free to skip to the goal 😊) Our…
-
Company Holidays
Currently Holidays can be configured in 2 locations on Smartsheet. At the administrator portal and at the sheet level. It would be ideal if at the sheet level you could select pull in holidays from your administrative settings. This should be something you can do when creating a new sheet from a template so that you do not…