Media & Entertainment

Media & Entertainment

Discussion List

  • tcalvey
    tcalvey 135 views 4 comments Most recent by Brianne Laird API & Developers
    First post 10/11/19,Last post 09/22/20
    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 & Developers1354
    tcalvey
  • KDub618
    KDub618 63 views 3 comments Most recent by Brianne Laird Formulas and Functions
    First post 12/04/19,Last post 09/22/20
    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 Functions633
    KDub618
  • Jwindels
    Jwindels 592 views 2 comments Most recent by Thomas Love Premium Apps and Integrations
    First post 11/19/19,Last post 09/10/20
    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 Integrations5922
    Jwindels
  • Alexander Wirtz
    First post 03/26/19,Last post 07/07/20
    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 Functions3436
    Alexander Wirtz
  • SeanR
    SeanR 858 views 3 comments Most recent by Cierr Formulas and Functions
    First post 02/27/19,Last post 06/25/20
    Hello All, We've been hunting high and low for a good task mgmt system for weeks, and Smartsheet is looking very promising. However, there doesn't seem to be any primary or foreign key type functions. How do you relate two sheets with eac…
    Formulas and Functions8583
    SeanR
  • Benjamin Hatmaker
    Accepted Answer Benjamin Hatmaker 127 views 4 comments Most recent by Andrée Starå Using Smartsheet
    First post 05/26/20,Last post 05/27/20
    Hi, I want to be able to validate data in a drop-down menu in one sheet from a column in another sheet. EX: I have a sheet that serves as a master sheet of projects and the project's properties (Name, budget, etc.), and another sheet that …
    Using Smartsheet1274
    Benjamin Hatmaker
  • LouiseM
    First post 06/06/18,Last post 05/20/20
    Hi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basicall…
    Formulas and Functions129125
    LouiseM
  • Roderick
    First post 06/12/19,Last post 05/19/20
    Setting up an alert system that sends out notifications when a form has been completed. To streamline the process I would like to use a field from the form in the email title to differentiate between the emails rather than a range of emai…
    Using Smartsheet664
    Roderick
  • Mattias
    Mattias 83 views 9 comments Most recent by Daniele Giassi Using Smartsheet
    First post 09/16/19,Last post 05/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 Smartsheet839
    Mattias
  • Shah_0614
    Email User Completed FormAccepted Answer
    Accepted Answer Shah_0614 99 views 3 comments Most recent by Andrée Starå Using Smartsheet
    First post 11/06/19,Last post 05/06/20
    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 Smartsheet993
    Shah_0614
  • Jeronimo
    Jeronimo 346 views 2 comments Most recent by bowser5 Using Smartsheet
    First post 03/14/19,Last post 04/09/20
    Hello, I am creating a dashboard and I need to add a resource view to it, to show the resources assigned to a specific project. Is there any way to do this? Also in the resource view, is it possible to limit the projects considered to ca…
    Using Smartsheet3462
    Jeronimo
  • jmhoward
    jmhoward 119 views 3 comments Most recent by Andrée Starå Using Smartsheet
    First post 02/08/19,Last post 03/04/20
    Hi there, I have my sheet set to show rows in descending order of dates, from most recent to oldest. However, when I use the card view, it shows the cards in the reverse order -- from oldest to most recent. Is there a way I can sort my c…
    Using Smartsheet1193
    jmhoward
  • thunt06
    Accepted Answer thunt06 22 views 3 comments Most recent by Andrée Starå Using Smartsheet
    First post 08/21/19,Last post 02/26/20
    Hello, I was looking all over the Community page and I was able to find the help I needed to make my statement work but when I changed the column in the statement it would stop working. I was hoping someone could explain the difference to…
    Using Smartsheet223
    thunt06
  • ANA G
    ANA G 319 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 Functions3194
    ANA G
  • MikeLord
    MikeLord 260 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 & Developers2609
    MikeLord
  • CamCrichton
    CamCrichton 1.1K 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 Functions11018
    CamCrichton
  • 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 Smartsheet943
    Loann McGee
  • Dereck H
    Closed Dereck H 6.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 Posts657517
    Dereck H
  • Michael.Baker
    Closed Michael.Baker 87 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 Posts872
    Michael.Baker
  • stuartr
    stuartr 108 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 Smartsheet1081
    stuartr
  • Loann McGee
    Closed Loann McGee 1K 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 Posts103120
    Loann McGee
  • SteCoxy
    SteCoxy 158 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 Functions15811
    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 Functions535
    dchouston
  • Judy C.
    Judy C. 77 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 Smartsheet771
    Judy C.
  • Laura Brady
    Laura Brady 42 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 Smartsheet421
    Laura Brady
  • dolores_ken
    dolores_ken 32 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 Functions322
    dolores_ken
  • seeble
    seeble 42 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 Functions424
    seeble
  • Loann McGee
    Closed Loann McGee 387 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 Posts3878
    Loann McGee
  • Daniel Dragoun
    Daniel Dragoun 67 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 Smartsheet671
    Daniel Dragoun
  • Monika Vermeulen
    Closed Monika Vermeulen 112 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 Posts11216
    Monika Vermeulen