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.
Transportation
Discussion List
-
First post 11/04/19,Last post 01/11/20I am trying to prove that the automation workflow alert that was set up actually sent out to one of my users. I can go to the View HIstory section of the Control Center intake sheet, but it does not show proof of who received the automati…Using Smartsheet384jennytracy -
First post 10/31/19,Last post 12/20/19I want to be able to display the data from the same cell in a sheet within the dashboard The sheet is updated using forms which put new data on the top row, but the value of the cell I had selected in the top row (now the second row) rema…Using Smartsheet324JohnJacksonP -
First post 04/30/15,Last post 12/12/19When using webforms and submitter puts in their name, if their name is already in contacts it doesn't match to contacts name. So you end up with a new name entry the same as an already existing name in your contacts column. Could they be…Archived 2015 Posts5442Mark Bonham
-
First post 08/09/17,Last post 12/06/19I am wanting to use smartsheet alerts to email me each day with tasks that are due and not completed. However they don't always come through each day despite it having the right set up To do this I use a form to add new tasks and then inc…Archived 2017 Posts336Ben W
-
First post 12/06/19,Last post 12/06/19Dears, Our customer has a number of unlicensed users which work on Smartsheet. A new employee joined and created a new free trial user account. This user is not able to email comments out of a sheet: "You've exceeded the maxim…Using Smartsheet224Mitch Van Riel
-
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/15/19,Last post 11/16/19I've been trying to find a solution to this but I'm coming up empty. Long story short, we use a Smartsheet form through a web browser on a phone to collect information. It's sort of an inventory process. At the bottom of the form there …Using Smartsheet231colonel00
-
First post 11/14/19,Last post 11/14/19I have a sheet that I have included the current inspection date. I need to calculate two expiration dates. One column @ 90 days post the inspection date and one column @ 365 days post the inspection date. Any help would be greatly apprecia…Formulas and Functions311nbeedy
-
First post 11/13/19,Last post 11/13/19For our smartsheet we keep track of vehicles that are or are not repaired. To keep track of how many "open claims" we have I am trying to count how many blank cells we have in the column that signifies if something is complete, b…Formulas and Functions448Billy-Rock
-
First post 11/07/19,Last post 11/12/19In MS Excel, you can use the Data Bars feature under the Conditional Formatting menu to create data bars within the cells. These can represent % Progress (see attached example). Is there a feature in Smartsheet that allows this? The Progr…Using Smartsheet551Jetlog75
-
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/19I am trying to create an automation that moves a row to another sheet based on a cell being changed to a specific value. In my case when I select a vendor to assign that project request to, I want it to move to a sheet that is their queu…Using Smartsheet192brian.gotti
-
First post 05/23/19,Last post 10/31/19I am working on a an extensive approval workflow with numerous steps and approvers. I am running into a challenge with getting the reasons why someone is declining a request to be part of the automation. Is there a way to allow for the u…Using Smartsheet6513Jed Rusyniak -
YM_Nor Cal Moving Services 22 views 6 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 10/04/19,Last post 10/28/19Hello, I would like for this form to go completely blank on ALL cell-rows before the update request gets sent to the collaborators (not licensed users) every week. I already have the update request set to send every Friday at 9AM to reque…Formulas and Functions226YM_Nor Cal Moving Services -
First post 09/05/17,Last post 10/23/19Good Day to ALL. I am new to the vommunity and need some help.... I have a survey form for my clients and when the results are populate, I would like to tally the results - by client. What I am looking to do is extract the number to the…Archived 2017 Posts6213deronbalch
-
First post 10/19/19,Last post 10/21/19Can't seem to get this formula to return a checked checkbox =IF(AND([Total cartons]@row > 5000, [Container Type]@row = "Cart",[Load Status]@row="Complete”),1,0) any suggestionsFormulas and Functions153Jed Rusyniak
-
First post 10/17/19,Last post 10/18/19I have 16 grids that all use a Contact List with 23 of the same client contacts. (1) its a HUGE waste of time to have to populate 23 contacts into a list 16 times and (2) every time a new person joins or leaves the team, I have to go into…Using Smartsheet292Cheryl Crouse
-
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/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/30/19,Last post 09/30/19Not getting notifications todayUsing Smartsheet113Larry.Reece
-
First post 09/15/19,Last post 09/15/19i am new to smartsheet and using it to keep track of inventory across multiple locations which have different contacts by location. What is the best method to send a scheduled listing of assigned assets to each contact owner. Would like …Using Smartsheet251Law$
-
First post 09/10/19,Last post 09/11/19I am having a new problem with an existing Smartsheet that has worked fine until now. Existing workflows have stopped working. The problem does not appear to be workflow, but something else going on. We have a workflow that triggers off of…Formulas and Functions176mikeb
-
First post 08/23/19,Last post 08/23/19Has anyone used Power BI with Smartsheet? I do a lot of things in Smartsheet, and we have another department doing things in Power BI. I see articles in Smartsheet about Power BI, but not sure what that means or if I have opportunities I…Using Smartsheet243bcase24986 -
First post 07/19/19,Last post 08/09/19Hello, Is there any way to extract the Cell history to calculate formulas. What I am trying to do is create metrics off the dates in the cell history. I.E. if a Dropdown list column starts on July 1 with Value 1 and changes to Value 2 on…Formulas and Functions616bhope51
-
Rosie.bradbury85341 14 views 5 comments 0 points Most recent by Rosie.bradbury85341 Using SmartsheetFirst post 04/15/19,Last post 07/25/19Can anyone support? I want to use smart sheets for auditing several branches in our company. Has anyone done this and can share an example?Using Smartsheet145Rosie.bradbury85341
-
First post 07/21/19,Last post 07/23/19Hello Smartsheet Friends, I have a single text box that I'd like to do some data analysis on, and wondering if there is a way. My text box is similar to the below "Product, Engineering, IT, Supply Chain, etc......." I want…Formulas and Functions297APotter
-
First post 05/17/19,Last post 07/23/19Good afternoon Smartsheeters ;) I am only new to Smartsheet and have started working on some existing docs. We have a very clunky and manual way of applying a designated PRIORITY number. When the sheet for each project/group of projects…Using Smartsheet605kristyf
-
First post 07/11/19,Last post 07/12/19Hi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into the Graph Types?Using Smartsheet291[email protected]
