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 2016 Posts
Archives for August 2016
Discussion List
creating a new user group by importing emails
Hi all, I have created a survey that I want to send to about 250 people. Most, if not all of these users are already in Smartsheet (at a global level). I've created a Group called "survey list" and want to add these 250 people. I exported these users to Excel and did some magic to create a comma separated list into aā¦
Android App - Shared sheets cannot be opened... "network error"
Has anyone else come across an issue where some (not all) of shared sheets cannot be opened using the latest andoid app? When trying to open a sheet, a "network error" appears. I've performed the same test on an iOS device, and it works fine.
Gantt chart, how to color weekends grey?
Hi all Simple question: I have a Gantt chart, but all is white. To make it easier to read, I want to color weekends grey. How can I do this? Thanks
Can you wrap texts in cards in card view? Can you print card view?
Hi Fellow Users, I am trying to wrap texts in each card in the card view but seem to not find that feature. Any tips? Also, is there a way to print/export the card view? Thanks, Afarin
Concatenate two cells
Hi, I need to concatenate data of two cell into one cell. I just use the formula "=[Cell1] + [Cell2])", which worked fine and gave the result "Cell1Cell2", however I need to have space or underscore between values of two cell like, "Cell1_Cell2" or "Cell1 Cell2". My practical requirement is: I need to concatenate "date"ā¦
Create dependency reminder by date
I'm looking to create a content tracker that includes a reminder to review once a document has reached a certain age. For example, Content piece one contains a column for "publish date", once 6 months have passed since that date, I'd like a status column with options of "current, needs review, outdated" to reflect statusā¦
I need a network diagram
Add my vote as well; I need this for my school and my company
Can the IF() formula use a conditional test from a different sheet?
..or does the test have to be within the same sheet?
Feature Request: Multiple column selection in Conditional Formatting
I have a customer that wants 7 columns to be the same format when a single condition is met. I would like a multi-selection option for the "Select what to format. This may even result in a performance improvement for this use case. Craig
Feature Request: JOIN argument range
Slightly related to: https://community.smartsheet.com/discussion/release-2016-08-06-formula-argument-declaration-confusion JOIN appears to be "vertically-centric", that is, designed more for joining text from a vertical range instead of a horizontal one. I would like to cherry pick cells from the current row to JOIN into aā¦