-
Preserving Indents when running a Smartsheet Report
Hi, I currenlty have a smartsheet with a bunch of tasks broken out into different sections. I separate the sections with different field values but to help with readability- I also do indenting in the task description field- this allows for the summary tasks to show as bolded. My issue is when I run a report to show a…
-
Contact Database
Hello! I'm new to smartsheet. I was wondering if there was a way to click on a company name and have it display all of the contacts associated with that company? I understand that you can link cells and link sheets but I don't want to create a sheet for each company. We have hundreds of companies and hundred of contact…
-
Attachment previews
I am wondering if there is any plan to add attachment previews as an option so that users have the ability to download just the document they may need from among others.
-
Calculate a whole number with a remainder
Hey All, I have a column that calculates the time a vehicle is in our fleet. It returns a whole number such as 500 days. Is there a formula that will convert that to number of years with a remainder being the number of days. (1 year 135 days). Any help is much appreciated. Thanks Dwayne
-
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…