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 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 Smartsheet1424Carly Sorensen -
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 Functions40916Dajah -
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 Smartsheet576RossL
-
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 Smartsheet819David 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 Functions396lisarae723
-
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 Functions402KDub618
-
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 Posts232Michael.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 Smartsheet221marthapapania -
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 Posts54720Sherri 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 Smartsheet155murray.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 Functions406@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 Functions211Brad 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 & Developers352Dean 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 Smartsheet251Shah_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 Smartsheet373DeinemNachbarn
-
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 Smartsheet211MikeCorvin -
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 Functions709Allison 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 & Developers273tcalvey
-
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 Functions261MikeCorvin
-
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 Smartsheet182smartsweet
-
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 Functions234seeble
-
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 Smartsheet171Josh 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 Functions4910Jess 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 Smartsheet171dmonkou105071
-
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 Functions223SherB
-
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 Smartsheet355BigAl
-
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 Functions161PStowers -
First post 09/03/19,Last post 09/04/19Hello, I have created a form and have a column named "Date Item is Needed" which is a date type column. However, the requestor needs to allow at least 10 days from the actual day. Is there a way to always black out those 10 firs…Using Smartsheet192@Help
-
First post 08/15/19,Last post 08/30/19I'm trying to calculate the total spend for a customer based on a list of transactions in another sheet in a specific date range. The dates in the sheet I'm trying to reference are classified as dates in the column properties and appear as…Formulas and Functions249MP22
-
First post 08/23/19,Last post 08/28/19My apologies if this has already been covered, but I didn't see anything specific to this subject when searching. I have a Excel sheet that has 45,000 + rows. The data in the rows are filled by 2 columns - United States Zip Code's and cit…Formulas and Functions321Jack C
