-
Support for Office 365 Sharepoint attachments
Our single largest GAP to fully fuel our workflow with Smartsheet is attachments as objects for Office 365. The Google Docs and Evernote integration is great, we simply need the same for Office 365. If I was to aim high at the wishlist I would like to see the modify date and last modified date attributes from Office 365…
-
Restricting of sensitive data
Good afternoon, Is there currently a way to restrict access to a document attached in SS - or is that on the horizon? For our use, most of our documents are able to be viewed by other departments. However, there are certain ones that contain propietary/confidential client information (NOT HIPAA) that we would not want…
-
How to find out how many columns am I using in a sheet/report
Good morning, I looked through and didn't see this question, so if it is posted elsewhere, my apologies. Is there a way to know how many columns you have on a sheet without having to manually count them? I know I have a few sheets with anywhere from 25-50+ columns, but I've not found a way to get a count automatically. Not…
-
View access only to a "set of rows" ?
Hi, When I share a Smartsheet, Is it possible to give view access only to a "set of rows" ? I have a sheet with hundreds of rows. But I want to select/define the rows collaborators can view and edit. Is it possible now? Thanks -George
-
Feature Request: Hyperlink to a sheet row in a different sheet
It would be great if there was a way to insert a hyperlink into a cell of a sheet that when clicked would take the user to the row of another sheet. This would be similar to the way one can can click on the Sheet Name for a given row to jump immediately to that row in the given sheet, opening a parent rows to reveal the…
-
Search functionality on attachment contents?
We are wanting to move our documents from SharePoint to Smartsheet. However, one small benefit of SharePoint is that a search done will return results of those keywords if they are in the body of the document, not just the title (excluding PDF's). Is this a function that will be made available in the near future for…
-
Order value based on price breaks
Hi, I have ~30 products each with four price breaks and I need to determine the value for each order (a single product type is listed per row) based on the ordered quantity and its associated price break. The really clunky method I have used so far is two main nested IF formulas and additional columns:- The first main…
-
Web Form - Weekly Project Updates
Is there a way to create a WebForm that would allow my Project managers to do Weekly updates on each "sheet" or project? If so, Can that information be placed in a central point? It appears I can only create a webform that update to a row in a sheet? Any thoughts, advice or comments would be appreciated. Sincerely, Scott S.
-
Task completion updates
Hi, I have created a production schedule sheet which is viewed by the guys in the workshop. I'm trying to find the best way for them to give me updates on task completion. I dont want to give them editor access to the sheet because this them the ability to change the row details (resource). I have a %complete coulmn which…
-
Absolute record references
Is there a convenient way to assign a fixed reference to a record that remains the same even if new rows are added or deleted anywhere above the record? Something like linking cells from another sheet, only within the same sheet, may work, too. I often want to refer to another record, but if the record number changes as…
