-
Hiding comments from external reviewers
We want to be able to send out a link to third parties and capture their feedback, but we don't neccesarilly want them to have access to our internal discussions. Since the publish settings only allow for read only or rich text (download with attachments and comments), I'm at a loss to figure out how to make it work. Can…
-
Sharing Templates
I use templates as my archive system. I want to share my template sheets with my supervisor, but I don't see a way to share templates. Can I? If not, it looks like I can move the sheets to a workspace to share. Should I build my archive in Workspaces instead of under templates?
-
How can our phone users set a filter to see lines by their name
Our company sheet has a column that is labeled responsible. I need our phone app users to be able to filter by their name as the sheet has about 500 lines to it. Any way this software can do that. We have people on Android and IOS.
-
Smart Sheet access
I just attempted to log into my account and everything appears to be gone. I have had access for a couple years now and as of Friday, could still access everything. When I log in now, it appears as though I am a brand new user. Is there an update taking place or another glitch that is currently causing issues? Who do I…
-
How to import data from another sheet
I am very fluent with Excel but find that it doesnt work completely the same with Smartsheet. I am trying to import data from another Sheet i.e. Sheet1 A1= 200 Sheet2 A1='Sheet1'!A1 How do I do the same thing with Smartsheet and then hide the formula?
-
Date as column type converts the date into US format but not accurately and hence makes the data ina
Column 60 is the accurate information Creation date has had the type specified as Date, it did not work with the dates in march until the 11th of March and likewise for the 1st of april. I am unable to understand the pattern either, can the Date format be used in dd//mm//yy format please
-
Purchase Order Forms
I want to create a purchase order form that I can send to suppliers by email from SmartSheets and receive a confirmation form back by email that the order is accepted with delivery details. The purchase order will need an internal authorisation. A unique PO number. Entry into the Smart sheet on authorisation. Ideally the…
-
Create an Entry on a worksheet based on the value of another worksheet
Problem Statement: We have one sheet (we will call it, Sheet A) which records the joiners/leavers for our company. In order to track whether the leaver employee returns his/her equipment, I wanted to create an entry with data from Sheet A on another sheet (Sheet B) based on two sets of criteria from Sheet A, Type (leaver)…
-
How to show the actual person who added information to a sheet
In smartsheet, you have the Created By and Modified By autonumber system properties. If you have created a web form, any responses provided via the web form reflect "web-form@smartsheet.com" in those columns. Is it possible to get the actual persons email who submitted the information via the web form reflected there…
-
duplicate entries
Can I set a column to warn of duplicate entries