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.
Discussion List
Dynamic Hierarchy
I am in the process of developing some work flow sheets for my team and I would like them to do the bulk of their submissions via web forms. Is there a way to create dynamic hierarchy whereby when a form is submitted, x criteria places that new submission under the correct "Parent"? Let's say that I have 3 Categories…
Enhancement Requests: Editable Published Sheets
When I create an editable published sheet, I'd like two improvements 1. Show 'locked' icon for rows. Column locks are shown, but the info column is hidden, so the row lock icon is not. 2. Allow publishing of a sheet without editor ability to add a new row. Since the sheet is updated via a WebForm, I can't lock all of the…
Track date change for column
Hi--I know I can track when any change is made to a specific row. And I know I can right click and see change history for any given cell. But is there a way to bring that date into the sheet itself so that it can be used in formulas (for example to compare the date that a certain event occurred in relation to the date a…
schedule email report to user for them to updat
I see the option to email shared users which sends them a link so they can view and update the data (if they have permisions). But it does not have a scheduling function. I see the option to email the report as an excel or pdf attachment. This has the schedule function, but no way for the user to access the report an…
Can you give users edit permissions to a sheet but not have them view it?
I assume you cannot do this, but need to verify; I want to send reports to various users with only their rows so they can update their part of the sheet. This report would have edit permissions. I will create another report showing the entire sheet with view only permissions. In order to update a the edit report, they must…
Update request - can you use a formula to select which rows to update?
I'm working on plan "C" of my idea to enable users to update rows assigned to them without risking accidental changes to another user's row. The update request is a powerful feature, but it requires manually maintaining row selection. On our sheets, the rows assigned to a specific user will change regularly. I want to…
Data retrieval
Help - I have deleted data from a sheet and the sheet refreshed unexpectedly when I closed it - can I get the data back?
Is it possible to automate the loading of excel into a smart sheet ?
Hi Team, Can somebody please help me automate (at regulare intervals) the process of loading local excel file into smart sheet. At regular intervals of time smartsheet data must be refreshed with excel data present on my desktop. Cheers Pavan Sreeramoju
Notification by Editors
Hi there Can a person that has a shared sheet as a editor.... make Notifications settings to other people?
Inconsistency with using Fix Version as JIRA Filter in Workflow
I'm not understanding the logic used by the JIRA Filters section of the Workflow builder. I'm trying to filter by unreleased versions. In the best case scenario (which I don't think is available), I'd be able to specify Fix Versions equals earliestUnreleasedVersion() or, better yet, more operators could be added and I…
