Legal

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.

Legal

 

Discussion List

  • David Skinner
    David Skinner 147 views 9 comments Most recent by Paul Newcome Using Smartsheet
    First post 08/21/18,Last post 01/08/20
    Has anyone received this error message before?  What are the options for large data?   (Image)
    Using Smartsheet1479
    David Skinner
  • hollywallace
    hollywallace 34 views 6 comments Most recent by hollywallace Using Smartsheet
    First post 11/16/19,Last post 12/05/19
    I work in the IT Department at a company. Another department assigns tasks to our department for software support for a particular application that they use. We would like for them to rank the tasks that they want us to complete - with num…
    Using Smartsheet346
    hollywallace
  • 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
  • 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
  • Beth Kennedy
    Closed Beth Kennedy 81 views 16 comments Most recent by Andrée Starå Archived 2015 Posts
    First post 04/06/15,Last post 11/28/19
    We currently have a team account and it appears when I add collaborators to the sheets, when they accept the smartsheet and setup in smartsheet with a "free trial"  I then get calls from them that their free trial is expiring,  I…
    Archived 2015 Posts8116
    Beth Kennedy
  • kari1282
    kari1282 35 views 6 comments Most recent by kari1282 Formulas and Functions
    First post 11/19/19,Last post 11/25/19
    Hi i'm trying to find all of the timekeepers that worked for a specific client.    Normally I would use Index Match however,  there are multiple time keepers that worked for the client and index match only shows one name. For Index matc…
    Formulas and Functions356
    kari1282
  • francescodantuono
    First post 04/16/19,Last post 11/23/19
    Cerco freelance italiano per assistenza 
    Using Smartsheet215
    francescodantuono
  • kari1282
    kari1282 39 views 1 comment Most recent by Paul Newcome Formulas and Functions
    First post 11/19/19,Last post 11/22/19
    Hi I'm trying to to create a sheet that tells me all of the timekeepers that work on a client from data from another sheet.  Currently I have sheet that list all of our clients and I will like to add a column that list all of the timekeep…
    Formulas and Functions391
    kari1282
  • Nasir@EBC
    [email protected] 27 views 1 comment Most recent by Andrée Starå Using Smartsheet
    First post 11/21/19,Last post 11/21/19
    Hi  I recently came across 2 date-related options which look inconsistent within the app.  Would be grateful if the smartsheet development team can address it soonest! The Inconsistency:  In the Workflow-Automation we can set a Condi…
    Using Smartsheet271
    [email protected]
  • Nasir@EBC
    [email protected] 60 views 4 comments Most recent by Mike Wilday Using Smartsheet
    First post 11/18/19,Last post 11/18/19
    Hi  Is there any limit to how many "automated workflows" we can create in a single sheet? Asking because one of my projects is expected to have approx 30 automated workflows in it.   (Image)
    Using Smartsheet604
    [email protected]
  • Nasir@EBC
    [email protected] 24 views 1 comment Most recent by Andrée Starå Formulas and Functions
    First post 11/14/19,Last post 11/14/19
    Hi All  I know how to lock a row when a certain condition (or a set thereof) is met. But is there a way that when a row gets auto-locked, all its child-rows also get locked automatically? In other words, some kind of inheritance mechanis…
    Formulas and Functions241
    [email protected]
  • Brad Huff
    First post 11/11/19,Last post 11/12/19
    I'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 Functions261
    Brad Huff
  • 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
  • Donni Matthew
    Donni Matthew 23 views 6 comments Most recent by Andrée Starå Formulas and Functions
    First post 10/31/19,Last post 10/31/19
    I am using this simple formula in a new field in Sheet Summary & I keep getting an "Unparseable" Error. =COUNTIF(RESPONSIBLE ENTITY:RESPONSIBLE ENTITY, "FIRM")  
    Formulas and Functions236
    Donni Matthew
  • kari1282
    kari1282 19 views 1 comment Most recent by Paul Newcome Formulas and Functions
    First post 10/29/19,Last post 10/30/19
    Hi I'm trying to auto calculate the date. I was wondering if someone could assist. I'm not quite sure how to do it I believe it should be an if statement but I'm not sure how to write it. I have a column that is Date of Last Correspondenc…
    Formulas and Functions191
    kari1282
  • Digit
    Digit 25 views 1 comment Most recent by Andrée Starå Using Smartsheet
    First post 10/29/19,Last post 10/29/19
    Hi I have created a form that is working perfectly in that once completed it is populating the sheet data.  I have also created a number of automation work flows that work if you directly input into the sheet but do not appear to work if t…
    Using Smartsheet251
    Digit
  • Nasir@EBC
    First post 10/24/19,Last post 10/25/19
    Hi  Does anyone know how to open the New Comment dialog using the keyboard? it's becoming more and more difficult for me to take the mouse EXACTLY at the same point and click, in order to add a comment to the currently active row.  We s…
    Using Smartsheet162
    [email protected]
  • Sandra Dye
    Sandra Dye 27 views 6 comments Most recent by Scott Willeke Using Smartsheet
    First post 10/17/19,Last post 10/19/19
    Hi. I'm looking for help troubleshooting an issue I"m having with Automation in smartsheet.  I set up a recurring request for updates to run each Friday at 8:00 AM PST to all Assigned To users in the sheet.  The problem I'm having i…
    Using Smartsheet276
    Sandra Dye
  • Digit
    Digit 30 views 2 comments Most recent by Scott Willeke Using Smartsheet
    First post 10/17/19,Last post 10/19/19
    We have an automated update request created, however, when it is triggered it sends a link to update all fields that need updating to all contacts within the sheet - as a result they are not using it as they cannot see which action is thei…
    Using Smartsheet302
    Digit
  • CLuke
    First post 10/04/19,Last post 10/18/19
    When using Conditional Formatting, I want to make my primary column change colors when a combination of choices are made in a multi select dropdown,. What it looks like now is this: If column 2 is 'condition' and column 3 contains 'condit…
    Using Smartsheet724
    CLuke
  • 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
  • CLuke
    First post 10/04/19,Last post 10/06/19
    When using Conditional Formatting, I want to make my primary column change colors when a combination of choices are made in a multi select dropdown,. What it looks like now is this: If column 2 is 'condition' and column 3 contains 'condit…
    Using Smartsheet261
    CLuke
  • 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
  • jtlsf1
    First post 09/30/19,Last post 10/01/19
    I want to assign a unique numeric value to each of the options in a drop down menu column, and have that numeric value display in an adjacent cell.   Drop down menu options in each cell are: Needs Contributor Contributor Reviewing Rea…
    Formulas and Functions386
    jtlsf1
  • kari1282
    kari1282 29 views 1 comment Most recent by Paul Newcome Formulas and Functions
    First post 09/24/19,Last post 09/25/19
    Hi,  I'm trying to figure out the due date for a submission if the dates remaining is >0 below is the formula I came up with, however it is not working.  =IF(INDEX({Due Dates}, MATCH([Client Matter]2, {Client Matter #})), {Days Remain…
    Formulas and Functions291
    kari1282
  • 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.
  • kari1282
    kari1282 34 views 3 comments Most recent by Paul Newcome Formulas and Functions
    First post 09/09/19,Last post 09/10/19
    Hi,    I'm trying to write a formula that would give me the total Number of request by person, that does not include Completed or abandoned. I used the following formula and it come up as nested criteria.  =COUNTIFS({Status}, @cell <…
    Formulas and Functions343
    kari1282
  • kari1282
    kari1282 53 views 2 comments Most recent by Paul Newcome Formulas and Functions
    First post 09/04/19,Last post 09/09/19
    Hi I'm trying to write a formula that will show me a column for the current Month    Currently formula =If(Month(date column)= 9, [Project]1)- This works and displays the correct cell, however I want the column to change with the month …
    Formulas and Functions532
    kari1282
  • Nasir@EBC
    First post 08/22/19,Last post 08/23/19
    Hi  I am new to Smartsheet, and hence am unable to perform the subject activity in it.  I have a set of 25 tasks called "Proofreading Tasks". And I have around 15 people in a team which is called "Team - Proofreaders"…
    Using Smartsheet213
    [email protected]
  • dbrown94726
    dbrown94726 20 views 5 comments Most recent by Andrée Starå Using Smartsheet
    First post 08/19/19,Last post 08/21/19
    Some of our projects go on for a very long time. Each group has their own list of projects. We add status notes in the Comments. The status notes can get very long and cumbersome; however, they are very beneficial for the project history. …
    Using Smartsheet205
    dbrown94726