-
Cell Link inside of a Template
Does anyone know if, or how, we can put a cell link inside of a template?... I'm looking to have all new sheets created with a template automatically have a link back to another sheet. Example... I have a template to start new projects with and I'd like to have another sheet that lists all the projects. So as new projects…
-
Template - Survey/Form "Rate our service"
Anyone have a template of a form (survey) they could share which you send out to client to request feedback on your service?
-
Copy and paste files
Can I recreate another folder with the same files with all the links? I created a set of files and populated it so I can test my formulas and generate dashboard. Now that its "fully" tested. I want to use the same set of sheets and dashboard for users with "blank" cells for users to start populating. But I want to keep the…
-
What formula(s) would work best for this task?
Hello Smartsheet community! I have a question regarding what formula(s) would work best for a specific spreadsheet I am building. The situation at hand: I have a spreadsheet with data that has been submitted through a Smartsheet form. This data is connected to a users alias and tracks their completion of training. There…
-
I've created templates of Sheet/Report and Dashboard Templates. If I copy them, will the link remain
I've created a folder containing templates for sheets and reports all linking to a dashboard for a status report. I want my team to be able to copy these and use them for their partners. How can this be done easily? If they create the sheets from Template and Save As the Reports and Dashboard, do they have to reset the…
-
Merge data from Smartsheet in Microsoft Word Document
Hello, I have been able to merge data from a smartsheet into a Google Doc Template using the smartsheet merge add-on. Works great. But, is it also possible to do the same thing but then in a Microsoft Word Document ? I have been asked that question by Microsoft users. Thank you for your help, Rudy
-
Can a smartsheet form autopopulate a PDF? Or can you push every row to a recreation of the form (in
Hi, We are using forms to gather group ideas for creative projects. After, we would like to take each form submission or row and populate to a formatted PDF that can be presented to the managers for approval. Is there a way to push a form submission to populate a PDF? Or link cells in smartsheet to a PDF? Or any other…
-
How do I change the columns on a task rollup report?
I'm trying to replicate the Task Rollup report that is available in the Smartsheet templates. However, for reasons I can't figure out, I'm unable to get different values for the Status column to populate the columns like the template does. Instead, it imports every task in the base file and it's respective status as rows.…
-
Kanban style dashboard
Hello, I would like to build a kanban style dashboard from a project plan or any other sheet that contains an action/owner/status. The second step, is I can create this Dashboard to bring together actions from multiple sheets. e.g. I can have action list 01 and action list 02. Bringing them together could show me the…
-
COVID-19 Vaccine Tracking and Distribution
Hello Healthcare Community! My name is Brianne and I work as the healthcare vertical program owner in customer success at Smartsheet. Over the last few weeks, we have been seeing an increased number of our healthcare clients having a need for COVID-19 Vaccine Tracking and Distribution planning. What do you need to see in a…
