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 February 2016
Discussion List
Viewing Responses Individually as a Form Instead of Spreadsheet
Is there a way to view reponses in the form view instead of just being able to view them as a spreadsheet?
Automatically Sum rows that have the same value in a specific column.
I would like to sum up the hours of a job according to what job number it has. This is going to be used as a Time Sheet. Therefore, mass amounts of entries are going to be sent to this report. I would like it to automatically sort the information and then sum up the hours of multiple cells that have the same job number in…
Protecting Smartsheet
I have several sheets starting with same first word as name and always delete wrong sheets due to oversight and undelete to get it back, whenever I bring it back, it loses the formatting i.e. size of columns and sharing. Right now, check and delete, sheet is gone. Is there a way that I can set warning or some protection to…
PayPal
Is it possible to use a PayPal button to submit Web-form?
Tracking Assets by location
I am not sure if this can be done in smart sheet. I need to track assets by location. There with be up to 50 assets by location and several thousand locations. I would also like t have the ability to add the bulk of the items from a location kit as all have common items with a few variables as to how many of each. All…
Inserted Image URLs
The ability to insert images into Smartsheet cells is fantastic! If you use an external service to connect to Smartsheet (ODBC, MS Power BI, Tableau, etc.) the image shows as "image-name.jpg". Would it be possible for it to show as the full URL to the image hosted on Smartsheet (AWS)? This would allow external services to…
Unique Values
I searched Help and the Community for "unique value" and did not find anything. Is there a way for a field in a sheet to be unique? For example, I want the Document ID column to be unique. Let's say I do not want to use the Auto Number property. Is there a way to ensure that all values are unique in a column when anyone…
Moving rows
Is there a way to move rows from one sheet to another and keep all the cell formulas that go with it?
Issues viewing Live Webinars
Hi all, I have been having issues viewing live webinars since the switch to the "GoToWebinar" format. I click the "join webinar" link that I receive via email and am brought to the webinar landing page. I can hear the audio (in real time) perfectly but my screen never refreshes so I miss out on the visual examples being…
Using formula to copy row to new sheet as a child row
We have created web forms to retrieve new client information and new project information. Both forms contain the Primary Column "Client Name". I know we can link cells from one sheet to another. But what I'd like to know is if we can set a formula (or link a sheet) so that when a new form is submitted (and it is added to…