-
Inventory help.
I am looking to use smartsheet for inventory. I have one item that we stock and I would want to scan the bar code in to record the s/n and when an order prints to be able to scan the bar code removing the item out of inventory. I used the "barcode inventory management" template but it works great for adding inventory but I…
-
Sort not working for Editors?
There is probably a easy explanation or fix for this but I can't figure it out. I have a sheet with about 10 editors that as things move on the sheet it needs to be resorted (sorted by a due date). For some reason I am the only one that can sort the sheet, the Sort option is greyed out on all of thier sheets - I've…
-
Change task Duration based on a condition in another cell
Hello Everyone. The projects I handle are the same each time in terms of the tasks to carry out. but they can differ in duration based on the 'size' of the work... I am using a standard sheet template which I also use to forecast, I would like to change the 'duration' of a set of tasks based on a dropdown that would return…
-
Row changes that don't affect Modified Date field
I see in your help documentation that changes to discussions and attachments do not affect the Modified Date type of System Column. Is there a reason for this? If a week-long discussion takes place within the discussion feature of a row, the Modified Date element makes it seem at first glance as if the toipic has not been…
-
Spreadsheet Pagination or Archive Rows?
Is there a feature or ability to turn on pagination for a spreadsheet? We have a few that have grown large and having lots of rows load in slows down the page loading and responsiveness. Ideally this would let you load the first page that shows rows 1-100, then page 2 would be 101-200, and so on. Anything like this exist…
-
Limiting editable access to certain users
Hello there everyone interested! We're looking to share sheets to various departments here however we don't want all cells to be able to be filled in (or changed) by all users. Is there a way that we can restrict editable fields to certain user accounts so user A can only edit columns 1-3 and user B can only edit columns…
-
Smartsheet connect to Tableau
Hi, I am trying to establish the connection between Tableau and Smartsheet. However, I do not have Admin Access to the smartsheet, And, I am not able to connect/configure ODBC using either username & password or the API Connection. Is this because I have 'single sign on' for the smartsheet or do I need to have the Admin…
-
Alerts not Sending to Assigned To Column
I want to send a daily reminder listing open tasks to contacts listed in my Assigned To column. All contacts have been shared to the sheet as Editor - cannot share. At least a couple of these contacts are users who have used SmartSheet before. I set a conditional formula in a reminder date field to populate with today's…
-
Restrict a user's access to Dashboard only
I am new to Smartsheet but learning fast. We are starting a project to use Smartsheet for client onboarding to our software. I intend to create a client-facing dashboard but would like to restrict a user's access so they cannot click on the Home tab which they have no reason to view and is just a place for them to take a…
-
Calendar View
Hi, Smartsheet team: I would like to know what are the differences between the SS's the calendar view and the Calendar View App available for purchase. Is it possible to create a master calendar that gathers all the information of individual calendars into one place? Is there any chance to get a trial period for that app?