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.
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