Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Archived 2017 Posts

Discussion List

  • Strike through automatically applied to new entries
    In Archived 2017 Posts
    In my sheet I have applied strike-through to two of my rows.   Now, when I receive new entries from a web form, all new entries are automatically showing in strike-through. I have NO conditional formatting applying strike-through font.    …
    1977 6
    Closed 2K views 6 comments Most recent by Mike Wilday
  • Expand/Collapse all functionality
    In Archived 2017 Posts
    I have set up a hierarchy within several sheets and I'm wondering- is there an Expand all/ Collapse all functionality for the 'nested' rows of data? Refreshing the page doesn't change anything within the sheet that is shared across 4 users…
    10348 10
    Closed 10.3K views 10 comments Most recent by Oscar Romero
  • Date AND Time format
    In Archived 2017 Posts
    Hi   I was wondering if there was / is a way to format a cell to be date and time format? We enter in when we contact a customer for the 1st time and have to track the date and time. It would be nice to do so with one cell where we click…
    7305 25
    Closed 7.3K views 25 comments Most recent by GoGators
  • Does Smartsheet to JIRA work with existing sheets & tickets?
    In Archived 2017 Posts
    I have an existing sheet that I want to use my new Smartsheet to JIRA connector. However, I cannot figure out how to link my exiting JIRA tickets which I have by URL already in smarsheet. Can this be done? 
    47 2
    Closed 47 views 2 comments Most recent by Matthew Neal
  • Using Resource View without 'named' Users
    In Archived 2017 Posts
    We want to use Smartsheet to build out our sales pipeline (consulting biz) and expected resource allocation. However, we don't have 'named' users (resources) until the project closes and we find the correct contractor.  Is there an easy w…
    747 15
    Closed 747 views 15 comments Most recent by Andrée Starå
  • Drop down menu in one box only
    In Archived 2017 Posts
    I have a housekeeping template for 150 different properties, and I want a drop down list on the top left corner in order to identify the property when it is checked.  Can that be done for just one cell?
    3337 12
    Closed 3.3K views 12 comments Most recent by Andrée Starå
  • Auto order (by date) in Card View
    In Archived 2017 Posts
    We have a project workload sheet that has columns of who a project is assigned to, completed, and new. There is no sorting or auto ordering of the projects that happen in each column (by start or end date). You can sort rows in the other v…
    922 10
    Closed 922 views 10 comments Most recent by nicole.naples104431
  • Circulatory Reference - checking if ISBLANK
    In Archived 2017 Posts
    I need to check if a cell is blank and if it is blank I need to populate it with data from another cell. When I say  =IF(ISBLANK([current cell]1), today()) It references it's own cell. Any suggestions?
    138 3
    Closed 138 views 3 comments Most recent by Andrée Starå
  • Publish with Filter ON
    In Archived 2017 Posts
    I have a card view that is set to display with a filter on by default.  Is it possible to also Publish this to the Web with a filter on by default?
    619 3
    Closed 619 views 3 comments Most recent by Rizzi-CTX
  • Exporting Contact Emails in Sheet to Excel
    In Archived 2017 Posts
    We have a contact column in our sheet with names and email addresses. I would like to export that information into excel but it will only export the names. Is there a way to get the email addresses? 
    1700 3
    Closed 1.7K views 3 comments Most recent by @khush_hello