-
Hyperlinks - Copying a Folder set where links stay with new sheets
Please tell me there is a solution for this.. I have a set of sheets, reports and dashboards. In one of the sheets there is a project plan and I've created hyperlinks to the relevant reports/dashboards within that folder. When I copy the folder, the hyperlinks refer to original sheets/reports and not the new ones. I've…
-
Leave of Absence Template?
Hello! I'm super new to SmartSheet and I've looked for a template (can't find one) for Leave of Absence. Is there anyone out there using SmartSheet to help them track the minutiae of employees out on leaves of absence (FMLA, non-FMLA, etc), tracking if medical notes have been received, returning employees in the HRIS,…
-
Template sharing within the community!
Love the community building, better yet when one of us has made a great work product, turn it into a template and share it. Make a community template library! Include owner's contact information should someone have a question. Then when someone takes it and makes it even better, share it again! Hyper-Collaboration!
-
How do I automate the creation of a project schedule from a form submission?
Hoping someone might be able to help me figure out this workflow: Form is submitted requesting a new project with the following information: name of project, requested go live date, assigned project manager This form submission triggers a workflow that will automatically pull a project template, inserts "name of project"…
-
Automatic project creation and reporting
Dear community, I have a scenario which gives me quite a headache. I would like to create a form which will be populated by the project requesters for creating projects in Smartsheet based on a set template. The form will have multiple fields. Once the form is submitted it will have to trigger an alert/reminder for…
-
PMO Template
I am struggling with the PMO template and the Schedule Health column in the Project Plan, which is indicating 'Red' even after a Task is complete, with this formula. =IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green")) Could I use a formula to ask it only to count if "Status" is…
-
Create templates WITHIN an existing workspace
Hi, We need the ability to create and use a template set within an existing workspace, without it creating a separate workspace. Steps: Create> browse templates> create from template but IN an already existing workspace without creating a workspace labelled with the template name.
-
RACI Matrix Template
Hey, does anyone have a RACI matrix template that they like to use in Smartsheet? I can't find on in the template section and online I am only finding Excel, sheets, and Word templates.
-
One project template, one set of dependencies and duration, but different start dates
Hi - I'm trying to create one project template, where tasks are the same, have the same dependencies and duration but the start dates may differ based on the project's complexity. One project has a longer lead time to kick things off from the other. And for the less complex variation, some of the timeline is compressed due…
-
Dashboard Widget Dividers
Is there an easy way to get a diving line or border between widgets on a dashboard? The only thing we've found is to insert images of lines from Powerpoint - not the best.