Discussion List

  • Current Task Formula based off certain criteria (symbols)
    In Formulas and Functions
    Hi,  I want to create a formula that would read all rows have a Green symbol and read back the last task name that has green. This would have to be based off the row number and not dates, given not every task will have a start or end date…
    47 5
    47 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Search and Replace, Conditional Formatting
    In Using Smartsheet
    I have multiple columns with a variety of drop-downs on many sheets.  Conditional formatting is set to many of the columns based on the drop down selection, sometimes up to 40 statements.  The problem I'm faced with is if I change one of t…
    3 3
    3 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • COUNTIF Formula for when a cell contains a specific word/phrase?
    In Formulas and Functions
    I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works.  …
    2098 2
    2.1K views 2 comments Most recent by Mike Wilday Formulas and Functions
  • Paste raw data into Filters
    In Using Smartsheet
    I love the Filter for "Show rows that match" is one of "select values". I however would love to be able to paste from NotePad, Excel, an email, etc a list of values separated by line or comma (IE: 5045,5046,5097,6014,50…
    39 1
    39 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Turn off Auto-Save on Android App
    In Formulas and Functions
    Is it possible to turn the auto-save function on the Smartsheet Android app 'off'? When our guys use the app on their tablets when they have a weak connection, after each cell there is a long wait untill it has saved. is it possible to tur…
    139 4
    139 views 4 comments Most recent by Andrée Starå Formulas and Functions
  • Web Content Widgets
    In Using Smartsheet
      Is the Web Content Widgets available in the free version of Smartsheet? Which plan do I get this Widgets, Individual, Business, Enterprise ou Premium Options?
    15 1
    15 views 1 comment Most recent by Mike Wilday Using Smartsheet
  • Searching within a large dropdown list
    In Using Smartsheet
    Hello,  I currently have an expense report for our company credit cards. On the expense report I have a drop down that lists all of the account numbers so that each line item can be posted to the correct account. There are hundreds of acc…
    312 2
    312 views 2 comments Most recent by Andrée Starå Using Smartsheet
  • Update existing smartsheet by excel
    In Archived 2017 Posts
    Hi,   I have a smartsheet with 4 columns: building code, name, cs manager name and supervisor. I create this smartsheet by import excel. Excel has 4 same columns..    However, cs manager always change.  We have 1000 buildings.   Admi…
    2064 7
    Closed 2.1K views 7 comments Most recent by Andrée Starå Archived 2017 Posts
  • Notifications and update requests
    In Using Smartsheet
    I'm automating the update request and reminder stages to update my activities. The worksheet is not shared, but I've enabled the alert permissions for the least restrictive. The actions and alerts indicator column appears in the reminder …
    177 8
    177 views 8 comments Most recent by SYSPK Using Smartsheet
  • Auto Sorting a column By date
    In Using Smartsheet
    I would like to sort my rows by soonest date automatically. I can do it manually but my issue is when other people have a filter on and save it scrambles the whole sort so i have to manually sort everytime to priorities rows. any ideas? 
    286 3
    286 views 3 comments Most recent by Andrée Starå Using Smartsheet