Templates
Discussion List
-
Licensed vs Admin statusIn Using SmartsheetDoes anyone else have a challenge with this mix of functionality? As a "free user" with admin access to a sheet, someone can move or copy entire rows somewhere else. But that same user cannot lock a row or columns. (And, while…
-
Time Tracking - Hours and MinutesIn Formulas and FunctionsI was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-ar…
-
Auto fill a second column based on a drop down selection using a formIn Formulas and FunctionsI understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy. Situation: I would like to have a form where someone selects one op…
-
Project Management Template- Why headers in row 1?In Using SmartsheetHi all, Smartsheets newbie. I've been playing with the project management templates (they're terrific!) and working on customizing them for our needs. My question is, why are column headers repeated in row 1 of in most (maybe all?) of the …
-
Auto Send Email TemplateIn Formulas and FunctionsHello guys, I'm trying to build Hiring Candidate Process so I want to build an automated sending email with a premade template, can smartsheet do that? for example: 1st interview => fail => send "thank you" email Thank yo…Answered - Pending Review 76 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
How to Fix: Value of Parent Row (days) Not Showing the Sum of the Childrens' Rows (days)In Formulas and FunctionsWe may have run into a bug with a value on a parent row. The duration of days should be 15 days because the sum of the childrens' rows is 15 (5 tasks, 3 days each), but the parent row displays 25 days. Where could this be pulling from? Ca…
-
How to copy a sheet without updating system generated columns Created By and Last Modified By?In Using SmartsheetI would like to back up a sheet that contains two system generated columns, Created By and Last Modified By, which currently are populated for all of the rows. When I tried saving the current sheet as a new sheet, all of my rows in the ne…
-
How to view your roadmap in SmartsheetIn Using SmartsheetHi All, I have just uploaded the Agile product roadmap template from smartsheet to create my roadmap in smartsheet account. After creation, I have not been able to visualise the end product as a roadmap (see image attached). Do i need to …
-
Dashboard Reporting Logical FilteringIn Using SmartsheetHello, I am currently devolping an Automated Dashboard Template that may function as a Site Visit Report. The project consists of developing thousands of Site Visits Reports, hence the need for an automated system and data entry. I develo…Answered - Pending Review 31 views 2 comments 0 points Most recent by CSuarezIntegra Using Smartsheet
-
Question on creating template tools that automatically feed and update rows to a central repositoryIn Using SmartsheetOur department was recently running into the issue of housing data and tools in consistent manner that allows for accurate department wide reporting without the need for additional administrative activities and duties to keep it up to date…