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.      Discussion List 
        
        
Feature Request-Bullets in Cells 
I am sure this has come up before, but I couldn't find it in a search for bullets. I am trying to use Smartsheet for proposals and it would be so helpful to be able to format a long list of items with bullets. I realize I can create them with bullets in a text editor and paste them in, but it would be much easier to workโฆ
 
Latest Discussion comment viewed in a cell 
I would like to request that the most recent comment in the discussion function be able to be mirrored in a cell in that same row. This would allow us to quickly scan a sheet full of data and see what the latest comment is without switching views.ย 
 
How much does it cost to get the Smartsheet-Jira integration piece? 
My company is looking into the Smartsheet-Jira integration tool. I have been tasked with finding out a pricing structure. I have gone to the website and requested help on four different occasions. However, nobody from Smartsheets has responded to my request. Does anyone know the price structure for thisโฆ
 
Turning flag red with conditional formatting 
Is it possible to turn a flag red using conditional formatting? I can turn the cell background red (or any other color), but not just the flag.
 
Formula for selecting checkbox will populate completion date 
Hello, I've looked through different discussions to see if I can figure this out. I'm trying to find a formula that will populate a cell with the date of when the checkbox in another cell has been selected. In other words, when I check this box that I have completed this item then I want another cell to populate the dateโฆ
 
Using Excel as primary data source 
I've been reading about the Live Data Connector feature in Smartsheet, but it doesn't sound as though it will solve my dilemma. I have a situation where highly confidential data in an Excel worksheet cannot (per policy) be stored in the cloud. However, not all of the data in the worksheet is highly confidential, and Iโฆ
 
Conditional formatting between sheets 
Hey! Is there a way to have a conditioning rule in one sheet and then have the format change in another sheet? The two rows are connected either by a cell linking or DataMeshing multiple cells together in the same row. Thanks! Aletheaย 
 
Conditional formatting based on location in hierachy 
Please consider incorporating a functions level() and has_cildren() in the conditional formatting and reporting filters. level() would give "0" if top level and "1","2" ... depending on the number of indentations. has_children() retruns true or false. Combined this would allow: - making filtered reports only extractingโฆ
 
Copy Rows Between Sheets Based on Checkbox 
I am trying to create a calendar or events based off a master list of events on another sheet. The source sheet is a master list of all possible events. That sheet contains a column of check boxes. When a checkbox is checked I would like it to automatically copy that row from the source sheet to the destination sheet. Theโฆ
 
Copy Column Properties 
Hi, I am creating a new sheet that needs to have 20+columns that are all a dropdown column type, with the same dropdown responses. Is there a copy function for setting up the columns? Thanks, Lisa