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.
Consumer Products
Discussion List
-
First post 07/25/18,Last post 02/10/20HI, I am using Smartsheet and I am involve in 3 projects and all are main and lead roles. I made 3 separate sheets for each project but I realize each projects affect the other projects and then sometimes the predecessor is in another sh…Using Smartsheet2015Dynamics -
First post 05/22/19,Last post 02/07/20My team and I are new to Smartsheet, and after 2 days of using the software, have already found a couple of major road blocks that will likely keep us from using Smartsheet. The biggest is the inability to create a drop down list that us…Using Smartsheet2069kaitlin -
First post 11/27/18,Last post 02/04/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 Functions82317Dajah
-
First post 05/21/18,Last post 01/28/20Can you add these features this year?API & Developers522mark.gipson27746
-
First post 05/31/18,Last post 01/24/20I understand there is no way to link directly to a file from dashboard unless it is in a cloud-based storage program. Has anyone found a workaround? We don't use this kind of storage and I want to be able to link directly to files. Savin…Using Smartsheet2664Carly Sorensen -
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 Smartsheet886RossL
-
First post 08/21/18,Last post 01/08/20Has anyone received this error message before? What are the options for large data? (Image)Using Smartsheet1479David Skinner -
First post 12/04/19,Last post 12/08/19Hi everyone! Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified" Here's …Formulas and Functions546lisarae723
-
First post 12/04/19,Last post 12/05/19Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…Formulas and Functions472KDub618
-
First post 08/07/17,Last post 12/01/19My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in E…Archived 2017 Posts402Michael.Baker
-
First post 11/18/19,Last post 11/22/19Hi. My team is looking to add a team travel calendar to MS Teams. I'd like to keep the MS Teams tab in the calendar view. What's the best way to easily get the calendar updated with team travel plans staying in calendar view? Thanks,…Using Smartsheet471marthapapania -
First post 08/21/15,Last post 11/18/19How do I hide a row, is there a specific from or sheet template that allows for hiding rows? I do see that hiding colums is possible, looking for the same functionality but for an individual row.Archived 2015 Posts106320Sherri Gartner
-
First post 11/13/19,Last post 11/15/19We have noticed over the last 6 months or so, that there is a persistant bug when using the "highlight changes" feature. The smartsheet will highlight changes within the given date range. However, it will also highlight other …Using Smartsheet205murray.ashmole
-
First post 05/29/19,Last post 11/13/19I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program. I'm hoping there's a way to automatically track inventory usage base…Formulas and Functions656@agredling
-
First post 11/11/19,Last post 11/12/19I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be cop…Formulas and Functions261Brad Huff
-
First post 11/11/19,Last post 11/12/19For example I have sheet A that has my master list and all components within a "Kit". On sheet B I have multiple kits and would like to reference all the included components. I get that you can link cell to another just like an…API & Developers532Dean Sund
-
First post 11/06/19,Last post 11/07/19I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken pla…Using Smartsheet391Shah_0614
-
First post 11/05/19,Last post 11/06/19Good Morning all, I established an approval workflow with a loop by using this: https://community.smartsheet.com/discussion/how-loop-through-workflow However, i would like to track the comments of the Approver for example. Sure he can in…Using Smartsheet533DeinemNachbarn
-
First post 11/05/19,Last post 11/05/19Is there any way at this time to add a photo into the title area of a form? IE on the one beneath where it says, "SmartSheet Popping Plate" Would there be any way to put a photo there of say a company logo? (Image)Using Smartsheet291MikeCorvin -
First post 10/17/19,Last post 10/18/19I'm very new to Smartsheet and hoping someone can help me. I have created a checklist, with different categories divided up by parent rows, and the tasks listed as children under the categories. I have a checkbox column and each task (in t…Formulas and Functions1399Allison Caskey
-
First post 10/11/19,Last post 10/14/19Hello All, We are using SS and considering DMS options (Efilecabinet, Box, M-file) to manage the bulk of docs we handle in the process. Wondering if anyone in the community that has a DMS in place can provide feedback or advice on their …API & Developers423tcalvey
-
First post 10/14/19,Last post 10/14/19I know you can create a sheet by importing a document into SmartSheet and having it auto-create around the information; however, how do you continue this? IE You take a sheet from Excel, that will continue to be used, and import it into S…Formulas and Functions331MikeCorvin
-
First post 10/07/19,Last post 10/08/19Am I being dense? I can see ways to automate a reminder based on conditions, but in a sheet with multiple submissions from one person, if I want to remind them ONLY if I haven’t received a recent update, I can’t say “don’t send if.” ? I c…Using Smartsheet242smartsweet
-
First post 10/02/19,Last post 10/03/19I'm trying to come up with the formula to dropdown only certain countries if chose certain region. I have two dropdown columns Region and Country If chose Region EMEA, country dropdown list will show DE, DK, NO If chose Region APAC, cou…Formulas and Functions324seeble
-
First post 09/27/19,Last post 09/28/19Hello smartsheet community, Initially I was tracking completed tasks with a "Done" column which would automatically format the row. After needing to add more options like "Cancelled", "In Progress" etc. I op…Using Smartsheet311Josh Hunsaker
-
First post 11/16/18,Last post 09/26/19We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and th…Formulas and Functions8110Jess Merritt -
First post 09/24/19,Last post 09/24/19My peers setup my profile when I joined Serta Simmons Beddings to get email notification of requests made to add new supplier to Streamline. I am still not receiving the notifications, although my peers are. My profile matches theirs app…Using Smartsheet231dmonkou105071
-
First post 09/13/19,Last post 09/13/19I've read through all the replies on this but have not found the resolution yet I want to display RYG balls in a new column i created that corresponds to the project Status and Finish Date. The new column Properties is RYG Balls The for…Formulas and Functions283SherB
-
First post 11/07/18,Last post 09/12/19Hi Community, we are using Status View at the moment to share the actual status of IT requests (Demands) to the requestors of different department. The access is given to the requestor via their email address they have to maintain while h…Using Smartsheet605BigAl
-
First post 09/12/19,Last post 09/12/19I am creating a Status field using IF function. I'm trying to look at a check-box field and return "status" (ex. "Tooling Complete") if the box is checked. I've tried IF(NOT(ISBLANK(... but a check-box formatted fiel…Formulas and Functions191PStowers
