-
Collect Ideas & Voting Functionality
Is there a Smartsheet template that collects ideas and allows other users to vote on the ideas?
-
Getting a Template's columns and rows using the API
Is there a method for retrieving a Template's columns and rows using the API? Trying to use the "Get Sheet" API method (e.g., /sheets/{sheetId}) with a Template ID returns a "Not Found". For now, I'm working around this by doing a "Create Sheet from Template", inspecting that temporary sheet as I need to, then deleting the…
-
Burndown Chart
I would like to use a burndown chart to track tasks of projects. Is there the template for burndown chart on Smartsheet?
-
Control Center optional template issue
Hi All, We are using Control Center for our projects, we use it with 4 different countries and every country has it own set of templates that they can select when creating a project. So in total we have 16 optional templates that are unrequired and unselected. The country then selects their own 4 templates. And creates the…
-
How do you move a row from one month group to another?
I am using a 12-month calendar template. I have content in one row for May, but need to move it to June. I know I can copy and past but this leaves behind the comments, files, and proofs. I have tried sorting in various ways and it does not seem to work. Do I have to change the formula? Or is there some kind of a way where…
-
How to Alter the "Sheet - IT Ticket Metrics"
I want to alter this sheet, found in the IT ticket Template, to just show the metrics for a specific customer. the original formula looks like this: =COUNTIF({Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1) and my attempt to specify to a single customer looks like this =COUNTIFS({Created Date Range},…
-
Emergency Preparedness with Smartsheet
Hello SS Community! Does anyone of examples of a Corporate Emergency Preparedness Checklist that one can share with me as a starting point? Tips greatly appreciated!! Thank you!
-
Can an email template be built in Smart Sheets that is sent out to a DL?
Can an email template be built in Smartsheet that can accept free form text in certain fields and also be able to be emailed out in the G-Suite to a DL. The other condition would be to be able to reuse the sent email message and be able to send subsequent email updates using the same email thread in the G-suite. Not sure…
-
Help with formulas to summarize data from multiple sheets
Hello, I have a Blueprint set up in Control Center that is used to provision new projects. I want to add a sheet to my template set to compare projected direct labor from the schedule we have set up with the actual direct labor we have feeding in through Data Shuttle. The schedule is set up with phases as the top level and…
-
Help: formula won’t apply to a new template
hello, when a new templete is submitted, my formula won’t apply to the new row. Other columns will apply the formula, however “End Time Parse Left” won’t. How can this be resolved? please see photo below: