Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Sheets
Discussion List
-
First post 01/23/20,Last post 01/23/20Hi! I have created a Row Report containing information from just one sheet, with one "What?" criteria. I have the desire to add another column to this report, that does not come from the original sheet, just for notes purposes. T…Using Smartsheet70Casey Sabatini -
First post 04/03/18,Last post 01/23/20i have a sheet that has data with dates added from a form. it always adds a new request from the form to the top and i have to manually sort it by date in descending. is there not a way to have it automatically add the data by the date in …Using Smartsheet24121lisa.nichols43261
-
First post 01/15/20,Last post 01/22/20I have rather long project sheets and several standard reports (Over Due Tasks, Tasks Due Next Week, etc) and include "Sheet Name" as a column in all. Each person is active on multiple sheets (projects), so all their assigned &a…Using Smartsheet163poweb048
-
First post 08/16/18,Last post 01/22/20Hi, I’m part of an in-house legal department. The company has different departments and different types of contracts/advice they require us to produce. To track the work, I have created one sheet for the legal team to use, covering all…Using Smartsheet9612Tomer
-
Register and calendar integrationAccepted AnswerFirst post 01/05/20,Last post 01/22/20Hi, I need assistance in creating a calendar which will show the number of locations where material deliveries will happen (5 locations) over 24 hours - 365 days a year. The idea is to then create a dashboard with the form and calendar an…Formulas and Functions4720sahilhq
-
First post 01/20/20,Last post 01/22/20Hi, I need to compare the hours allocated to the hours actually worked, through timesheets. For this I am using a spreadsheet to aggregate all the data from timesheets in order to extract metrics of hours worked by time and in which proj…Formulas and Functions291soeirorenan
-
First post 01/22/20,Last post 01/22/20I have an automation workflow in one sheet that I want to use in a different sheet. Is there a way to copy this workflow and then add it to my other sheet (similar to how you can copy summary reports from sheet to sheet)? Or do I need t…Using Smartsheet131sdonnelly -
First post 11/27/18,Last post 01/22/20I 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…Formulas and Functions39516Dajah
-
First post 08/10/18,Last post 01/22/20Is there a way to have a row come in automatically at the same indent level as the row above it? My top row is a parent row with calculations based on all of its children. The children rows are all web form generated and they do not come i…Using Smartsheet476RossL
-
IF NOT ISBLANK helpAnsweredAnswered Zachary Mitchell 19 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/21/20,Last post 01/21/20I'm trying to create a formula that will display the different colored dots in the status bar. I had success at first but one part of the formula isn't working with the others. I need it to display BLANK if Patient is blank, Gray if patien…Formulas and Functions193Zachary Mitchell
-
First post 01/25/19,Last post 01/21/20Hey team I have been using SmartSheets since day one and I continue using it. I have a question about a report that I have built. I have a report that I have built that pulls in all my projects plans title ROW 1 based on a where clause fo…Using Smartsheet395Kelly.Brady76386
-
First post 12/07/19,Last post 01/21/20My project contains multiple sheets that need to be summarize. Each sheet has a sheet summary but since my data spans across multiple sheets, I need to combine the calculated fields in my sheet summaries to be combined (sum, average, count…Using Smartsheet642awollam105821
-
First post 08/15/18,Last post 01/20/20I am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it. Thanks!Using Smartsheet635Sgiovinazzo
-
First post 02/20/18,Last post 01/20/20Is there a way to set a particular field to accept more than 4000 characters? We use SS for managing projects and the "Notes" field we have established is where we run into issues. On occasion, we need more than 4000 characters.Using Smartsheet1017KMart
-
First post 01/17/20,Last post 01/20/20https://us.v-cdn.net/6031209/uploads/670/YQNPWNG4G3XF.png I have tried this several times but the filters I create before saving as a template do not appear in the derived sheet. The check box above leads me to believe the filters should …Using Smartsheet131John Laycock
-
First post 03/18/19,Last post 01/20/20Hello I have a parent row on a sheet and I would like new entries that flow into that sheet through a form to be automatically indented so it's a part as a child row to the parent row from the beginning. Also, there is a formula that isn'…Formulas and Functions578Lindsey P -
First post 01/14/19,Last post 01/18/20Hello. Is there an option to allow text formatting/editing (such as bullet points, bolding, italics, hyperlinks) in a form linked to a smartsheet? I have a column in a sheet named description, which I would like users to give a comprehensi…Using Smartsheet755ray
-
First post 01/17/20,Last post 01/17/20Hello, I am having the exact same issue as Thor did in 2015 - https://community.smartsheet.com/discussion/385/losing-data-2 I sent out a current user view report to my project managers and when they all update their individual rows/report…Using Smartsheet200Gita Puvvada
-
First post 11/21/19,Last post 01/17/20While trying to figure something else out, I stumbled across a new option for having specific actions date/time stamped using the stem generated Modified (date) type column and the new Copy Row automation. . DISCLAIMER: This does not sc…Formulas and Functions658Paul Newcome -
First post 09/19/19,Last post 01/17/20I have inherited PMO reposinsibility for a large program in Smartsheets. I am going through the process of linking the various schedules, finance/risk/issues registers and other sheets for about 15 projects, all of which link into sub-prog…Using Smartsheet305Kyle Furner
-
First post 01/14/20,Last post 01/15/20Hi, I work in construction and after our project managers inspect a project in the field I'd like them to have the ability to generate an inspection form for the property owner to sign on site using a tablet. Right now they are using a sh…Using Smartsheet225Ian B
-
Proofing- Previous VersionsAccepted AnswerAccepted Answer Conner Sherman 40 views 10 comments 0 points Most recent by Conner Sherman Using SmartsheetFirst post 11/28/19,Last post 01/14/20Hello everyone, I have been using the proofing feature in our team for internal proofing. I have an issue where as soon as you add a new document version, the previous versions are no longer visible they sit loading. You can still down…Using Smartsheet4010Conner Sherman
-
First post 12/20/19,Last post 01/14/20Hi, I am trying to create a meeting minutes template which both facilitates taking minutes against an agenda and also automates distribution of minutes to 'Attendees' when ready. I am using multiple rows to list Agenda topics (under a par…Using Smartsheet527Jocelyn Bailey
-
Accepted Answer Marco Leippert 27 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 01/10/20,Last post 01/12/20Hello, to present an overwiev of the projects I´m managing with Smartsheet I need a more "presentable" version of the Gantt chart. Is there any chance in Smartsheet to make the Gantt look different, for example to make some tasks…Using Smartsheet271Marco Leippert
-
First post 09/16/19,Last post 01/11/20Thought I would start my own thread regarding this since it seems very quiet around this change. Am I the only one having no luck in using the suggested shortcut CTRL ] to indent? I am using Windows 10, Chrome webbrowser and swedish keyb…Using Smartsheet258Mattias
-
First post 03/13/19,Last post 01/09/20Hello all! I am trying to work with the MATCH and VLOOKUP functions, to create alerts to let people know it's time to begin their assigned work. For example, if Task 2 is a predecessor of Task 3 (that is, if [Predecessors]3 = 2), I wan…Using Smartsheet899Dave Robinson
-
Answered Josh Robichaud 54 views 2 comments 0 points Most recent by Josh Robichaud Formulas and FunctionsFirst post 01/08/20,Last post 01/09/20Hello, I have a column in my sheet that is populated by a multi-select drop down in a form ("Violation" column below). Once submitted, the cells in this row will contain at least one, but typically multiple entries from the mult…Formulas and Functions542Josh Robichaud
-
Save Button For WebformsAnsweredFirst post 01/08/20,Last post 01/09/20Hello Smartsheet, I have seen multiple threads from as far back as 2015 asking for a save button for webform https://community.smartsheet.com/discussion/1909/saving-coming-back-to-a-partially-complete-web-form https://community.smartsheet…Using Smartsheet221Jia Lee
-
tcanelli41471 46 views 3 comments 0 points Most recent by Andrée Starå Premium Apps and IntegrationsFirst post 03/15/18,Last post 01/09/20Is there anyone that would be willing to work with me on the phone to work through this issue: I've created a sheet that has over 40 columns - it's my "master" sheet that feeds a bunch of reports that will be utilized by differe…Premium Apps and Integrations463tcanelli41471
-
Countifs syntax killing meAnsweredAnswered Shawn Borror 23 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/08/20,Last post 01/08/20I want to count number of projects on hold AND change control = resource constraints This is what I"ve tried; =COUNTIFs([Portfolio Rollups Range 8], "Hold", {Portfolio Rollups Range 9}, "Resource Constraints")Formulas and Functions233Shawn Borror
