-
Formatting Date in Smartsheet with Month Name Displayed
When using the column type of "DATE" the only way dates are always displayed as numeric values. However, some of my colleagues are requesting that the dates be displayed as Feb 12, 2016 or 12 Feb 2016, etc. Is this possible in Smartsheet? The only preferences I have located are the user preferences where you localize your…
-
Signature in Smartsheet
Is it possible to add a signature in my Personal Settings that I will have automatic signature in all my mails from smartsheet, even when I'n sending rows to somebody. Kind Regards, Ivan
-
How to count different status from one column
Dear all! In our projects we use smartsheet as data base for elements of decor. At the moment we have four different statuses on each elements. In this case would like automatically count all red, blue, yellow and green statuses and see how many elements we have on different production stage. I know how to coun all…
-
Printing highlighted changes
Hello! How do I print a sheet that has highlighted changes shown? If I send it directly to the printer or export the sheet the highlights disappear. Does it matter if the sheet is "View Only"? Thanks, Peggy
-
Improving the context of answers to community questions
Hi all, can I suggest that as there are lots of new users to the community since it was launched only a few months ago, that existing and new members add a little detail about themselves? That extra info should make it easier to see the context in which a question is being framed, so the answer is more appropriate?…
-
IF(Is Parent Row....
I am using the below to calculate the "days since last contact" and it works nice. However, if the row is a parent I want to retrun blank, i.e. <> =IF(OR(TODAY() - [Last Contact Date]10 > 0, [Last Contact Date]10 = TODAY()), TODAY() - [Last Contact Date]10, "Never") The formula for check is a parent row is…
-
Conditional Formatting
I have a question that someone may be able to help me with. If I have a column called Finish Date. On line 5 - I enter a date that my customer wants project to be finished On line 4 - I have a automatic date that is from a predecesor based on finish date so that it populates automatically depending on the tasks completed…
-
Webforms for help requests - best practices
We have a webform created that our customers can fill out to submit help requests. What is the best way to disseminate this webform and make it available for them to fill out? I don't want to have to email it to them, but at the moment I don't have a space on a webpage to embed the link/form. Would that be the best way to…
-
Web Form
Hi there, I was wondering if there is a particular access level where someone can see and/or edit a web form without having access to the data behind the scenes? I'm asking because the person isn't computer savvy and gets overwhelmed easily but would like to be able to edit the webform since it will be used by her to fill…
-
Google add-in: "Combine into one file" changes the orientation of the document
Hi there, Help! I'm using the SmartSheet add-in to print onto custom envelopes via Google Docs. I've laid out the merge fields so they print in the right spot of my envelope. The doc in Google is Landscape. When I create individual PDFs or Google Docs, they appear as landscape too. However, when I "Combine into one PDF",…
