Media & Entertainment

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.

Media & Entertainment

 

Discussion List

  • ANA G
    ANA G 67 views 4 comments Most recent by Margaret Conklin Formulas and Functions
    First post 10/07/19,Last post 02/12/20
    I am trying to auto populate effective dates for benefits and I cannot get the calculation to work past the first part (60 days after start date) I need to have the following result as an example   Start date: 1/15/2020 Effective Date:…
    Formulas and Functions674
    ANA G
  • MikeLord
    MikeLord 81 views 9 comments Most recent by Andrée Starå API & Developers
    First post 09/24/18,Last post 02/09/20
    I need to be able to generate a simple format based on the data that exist in smartsheets. I store information such as news updates and I would like to be able to create a report that generates the text formatted in a specific way. For in…
    API & Developers819
    MikeLord
  • CamCrichton
    CamCrichton 228 views 8 comments Most recent by Paul Newcome Formulas and Functions
    First post 12/20/18,Last post 01/23/20
    I have a sheet with a list of assets. There is a pull down menu that defines the status - I need to know when the menu is set to "complete". I can do that easily with a filter - but I want to cull the entries before a specific da…
    Formulas and Functions2288
    CamCrichton
  • Mattias
    Mattias 44 views 8 comments Most recent by Andrée Starå Using Smartsheet
    First post 09/16/19,Last post 01/11/20
    Thought 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 Smartsheet448
    Mattias
  • Loann McGee
    First post 02/22/19,Last post 12/31/19
    Good morning, I've discovered that text is no longer behaving well within the cell. I'm see words cut off within the cell, whether or not the cell is formatted to wrap the text. Thus, it makes copying the text and pasting it wonky. I oft…
    Using Smartsheet543
    Loann McGee
  • KDub618
    KDub618 47 views 2 comments Most recent by Paul Newcome Formulas and Functions
    First post 12/04/19,Last post 12/05/19
    Hi 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 Functions472
    KDub618
  • Dereck H
    Closed Dereck H 1.6K views 17 comments Most recent by PrarthanaP Archived 2017 Posts
    First post 05/20/17,Last post 12/03/19
    Have a super basic question I just can't seem to find a quick answer for. Want to sum cells with both numbers and text in them like "15 min" + "15 min" and get the result of "30 min". I formatted the cell wit…
    Archived 2017 Posts163417
    Dereck H
  • Michael.Baker
    Closed Michael.Baker 40 views 2 comments Most recent by Ford Archived 2017 Posts
    First post 08/07/17,Last post 12/01/19
    My 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 Posts402
    Michael.Baker
  • stuartr
    stuartr 50 views 1 comment Most recent by Alejandra Using Smartsheet
    First post 11/26/19,Last post 11/27/19
    Hi - our company is looking to hire out a hospitality box in London for a 12-month period that hosts events all year round. We would like internal employees to be able to view the event calendar and to book slots for a specific date where …
    Using Smartsheet501
    stuartr
  • Loann McGee
    Closed Loann McGee 204 views 20 comments Most recent by Andrée Starå Archived 2015 Posts
    First post 06/23/15,Last post 11/27/19
    Good afternoon, I'm not aware of a current way to do this, so I'm wondering if it's on the dashboard for enhancements. In our use, we find ourselves needing to attach/copy the same documents from one line to another and currently the onl…
    Archived 2015 Posts20420
    Loann McGee
  • Jwindels
    Jwindels 88 views 1 comment Most recent by PPS Solutions Premium Apps and Integrations
    First post 11/19/19,Last post 11/20/19
    Does Smartsheet allow for integration with Access database tables? Is this something that a connector is needed for; such as Data Uploader? Will the integration work with older editions of Access or only Microsoft 365?
    Premium Apps and Integrations881
    Jwindels
  • Shah_0614
    Shah_0614 39 views 1 comment Most recent by Andrée Starå Using Smartsheet
    First post 11/06/19,Last post 11/07/19
    I 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 Smartsheet391
    Shah_0614
  • SteCoxy
    SteCoxy 37 views 11 comments Most recent by Paul Newcome Formulas and Functions
    First post 10/18/19,Last post 10/25/19
    Hello, Hoping you might be able to assist me with a similar issue I'm experiencing. I've attempted to import a Trello board into Smartsheet for one of my colleagues and I'm getting the same error message, when I view it in grid view on so…
    Formulas and Functions3711
    SteCoxy
  • dchouston
    First post 09/11/18,Last post 10/15/19
    Hi all, We're using Smartsheet to plan content development and scheduling for a radio station.  We'd like to create lanes in the Card View for each day of the week (I already know how to do that part).  But each row in grid view already h…
    Formulas and Functions365
    dchouston
  • tcalvey
    tcalvey 42 views 3 comments Most recent by Andrée Starå API & Developers
    First post 10/11/19,Last post 10/14/19
    Hello 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 & Developers423
    tcalvey
  • Judy C.
    Judy C. 31 views 1 comment Most recent by Mike Wilday Using Smartsheet
    First post 10/07/19,Last post 10/07/19
    I have my priorities set up for high, medium, low.  I'd like to prioritize within the highs, lows, etc. I'm used to working of an ABC, 123 set up.
    Using Smartsheet311
    Judy C.
  • Laura Brady
    Laura Brady 26 views 1 comment Most recent by Alejandra Using Smartsheet
    First post 10/04/19,Last post 10/07/19
    My org used to use the “Send” or “Send Update Request” option from the fly-out menu on each row quite frequently. That feature is now only available to licensed users, I believe, as Smartsheet moves people to use conversations in the comme…
    Using Smartsheet261
    Laura Brady
  • dolores_ken
    dolores_ken 26 views 2 comments Most recent by dolores_ken Formulas and Functions
    First post 10/04/19,Last post 10/07/19
    Hi, I am trying to get the % of tasks complete. The column is a checkbox type. This allows me to get the number as long as all columns are 1 (checked) or 0 (unchecked)  =ROUND(100 * (COUNTIFS(ES2:ES36, 1) / COUNT(ES2:ES36))) + "%&q…
    Formulas and Functions262
    dolores_ken
  • seeble
    seeble 32 views 4 comments Most recent by Paul Newcome Formulas and Functions
    First post 10/02/19,Last post 10/03/19
    I'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 Functions324
    seeble
  • Loann McGee
    Closed Loann McGee 109 views 8 comments Most recent by Kara Lumley Archived 2015 Posts
    First post 06/24/15,Last post 10/01/19
    Good afternoon, A question was asked of me today if there is multiple choice column in development. We use the drop-down list column, but one that allows you to choose multiple entries would be fantastic. Blessings, Loann
    Archived 2015 Posts1098
    Loann McGee
  • Daniel Dragoun
    Daniel Dragoun 26 views 1 comment Most recent by Andrée Starå Using Smartsheet
    First post 09/27/19,Last post 09/27/19
    Hi, we are displaying dashboard on TV on open space hall. To keep TV login secure, we are using account without licence, and this user is Viewer only. But when we tried to set up Auto-Refresh rate to 1 minute (it is important to see dashb…
    Using Smartsheet261
    Daniel Dragoun
  • Monika Vermeulen
    Closed Monika Vermeulen 32 views 16 comments Most recent by jtallman Archived 2015 Posts
    First post 03/01/15,Last post 09/25/19
    Update requests are great, however none of the comments get stored within Smartsheet but only get sent as a part of an email. This way discussions get lost that should remain part of the row it is about. Copying and pasting these discussio…
    Archived 2015 Posts3216
    Monika Vermeulen
  • Stian Totland
    Closed Stian Totland 49 views 12 comments Most recent by Marc Shecter Archived 2016 Posts
    First post 03/14/16,Last post 09/23/19
    It is possible to drag 'n drop rows to change their order, but if you order by some column this "index order" is lost. I need some way to prioritize rows, with the most important at the top. I can do this by adding a column of ty…
    Archived 2016 Posts4912
    Stian Totland
  • Daniel Murtagh
    Daniel Murtagh 34 views 4 comments Most recent by Andrée Starå Formulas and Functions
    First post 09/08/19,Last post 09/17/19
    Hi there Smartsheet Community! I have been a smartsheet user for a few years now but this is my first post with the community (so i'll try my very best to describe my issue) I use two different sheets for planning in my company, which is…
    Formulas and Functions344
    Daniel Murtagh
  • Alexander Wirtz
    First post 03/26/19,Last post 09/12/19
    I want to use smartsheet as an international project management tool. One thing is driving me creasy. I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario.…
    Formulas and Functions813
    Alexander Wirtz
  • Glenda K.D.
    Glenda K.D. 35 views 3 comments Most recent by Andrée Starå Using Smartsheet
    First post 09/10/19,Last post 09/11/19
    Is there a way or setting where I can control how email alerts are sent when multiple rows match the criteria? For a while, even if multiple rows matched the criteria, we would always get individual emails/alerts for each row. (i.e. 6 row …
    Using Smartsheet353
    Glenda K.D.
  • ron.zanetti53836
    First post 03/15/19,Last post 09/04/19
    Hello community! Anyone have a work-around for this? Here's the situation: I’ve created a vlookup formula in my sheet to obtain an email address from another sheet, and then want to alert someone using the email address result from the fo…
    Using Smartsheet186
    ron.zanetti53836
  • Dereck H
    First post 09/09/16,Last post 09/01/19
    I know I've asked this in the past like 3 years ago but don't know if there mght have been a feature update or workaround for this yet.   Is there a way to check multiple boxes or tag multiple items within a single cell? If I made a drop…
    Archived 2016 Posts574
    Dereck H
  • Jack C
    Jack C 65 views 1 comment Most recent by Alejandra Formulas and Functions
    First post 08/23/19,Last post 08/28/19
    My 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 Functions651
    Jack C
  • Philipp Salomon
    Philipp Salomon 28 views 1 comment Most recent by Andrée Starå Using Smartsheet
    First post 08/27/19,Last post 08/27/19
    Hi There, my support team has to check 600 - 800 technical setups on a weekly basis. They have to approach all systems physically and do certain routines. We want to use Smartsheet and its forms to easily document that process and genera…
    Using Smartsheet281
    Philipp Salomon