-
Feature request: Hashtags to create automatic reports
Hello! So, the story is: Our team is using a Smartsheet workspace to coordinate the production and deployment of assets of an entire Content and Marketing department. We have created sheets for each type of process/asset (Social Media, Video, Print, Web, Email Marketing, etc), automated formatting in all sheets according…
-
Keeping Track of Completion Dates and Updating Status
I am relatively new to using Smartsheet, but here is what I'd like to be able to do. I have a Course Development Tracker sheet that lists courses to be developed in the next term. My team has a 60 day development process, with 5 checkpoints. Each checkpoint should be met by a certain number of days from the due date. CP#1:…
-
Populating external Reports with Smartsheet Data
Hi, Is there any way that I can export my data from smartsheet so that it automatically populates/merges into a template that i have (word document) Thanks in advance, Scott
-
Imported Formulas from Excel
Happy Wednesday! I have been going in circles trying to figure out where this formula is going unparseable. I researched it against other similar (working) formulas in smartsheet and the Formula errors guidance- but I am still missing it- hoping a fresh set of eyes can help me pick out the culprit. Thank you!…
-
Look up and sum costs of selected features
I am building a form and associated sheet/workflows to track requests for vehicles from our customers. I'm hoping to find a formula that would allow me to use features chosen in multi-select columns to look at a different sheet where the costs of each feature are organized, and return the total cost of all the features…
-
Sheet Location (Workspace/Folder) on Sheet
Is there a way to show the sheet's location on the sheet itself? Where the workspace name or folder name or both would show on the sheet?
-
WBS in smartsheet.
Hi. Is there a way that I can have a dewey decimal system kind of the numbering for the items on my worksheet. I have found a solution that lets me have items numbered in the format 1.1 and 1.1.2 and 1.1.2.4 etc. But I want a system where I can have the format 01.00.00.00 and 12.04.09.11 etc; How do I make sure that there…
-
How do you see which reports are connected to a sheet?
Hey everyone! I am trying to track down all of the reports that are connected to a sheet. I am planning on rebuilding the sheet but know that it is connected to a lot of reports that other people in my company use so I don't want to miss anything. Is there a way to pull a list of all reports that have this sheet as a…
-
Manpower Boards in Smartsheet
Hi there! Is anyone using Smartsheet as scheduling tool for weekly Manpower, basically for the field staff, supers, Forman etc. so they know which project to report to week by week. Used excel in the past but wondered if anyone found a good setup for this here. Would love to hear some ideas.
-
Update Existing Main Sheet Field from Data That is Entered on Another Update Sheet
I've looked through the forums and docs and haven't found an answer yet. I think it could possibly be done using COLLECT, JOIN and MAX using certain criteria to match on. Perhaps someone has found a solution to a similar scenario. We have a main sheet (Unit Tracker) where we collect all data related to manufactured units…
