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.
Strike through automatically applied to new entries
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. It's frustrating since I cannot read the new entries and I have to clear-out the…
Expand/Collapse all functionality
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. Mendy
Date AND Time format
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 the cell and a time stamp of now (but editable) is available. Is this a current feature…
Does Smartsheet to JIRA work with existing sheets & tickets?
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?
Using Resource View without 'named' Users
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 way to utilize resource views but without having named users invited into the smartsheet…
Drop down menu in one box only
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?
Auto order (by date) in Card View
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 views, but not card. Help, please.
Circulatory Reference - checking if ISBLANK
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?
Publish with Filter ON
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?
Exporting Contact Emails in Sheet to Excel
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?