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
Update Request - Emphasize the link to "Go to the sheet"
On the Update Request email, there is a big "Update Form" button. There is also a hyperlink in tiny type at the bottom of the email that the user can click to "Go to the sheet". It seems the "Go to the sheet" functionality is more likely to be the desired usage of the Update Request email than to launch a web form. Could…
Recurring Reminder
All, Looking to setup a recurring reminder for every Friday. I do not want to send an update request. I simply want an email sent every Friday to everyone sharing a sheet instructing them to update their tasks before a recurring Monday meeting. The email would contain a link to the sheet, similar to when you first share…
Copying from excel 'cell' level to smartsheet cell
I need to transfer a great deal of cell level data (including sketches that have been inserted) from an excel worksheet into my smartsheet. There doesn't seem to be a paste functionality at the cell level?? Or am I missing something really obvious?! thx!
Cant remove someone from a sheet / workspace
When I try to remove someone I have shared a sheet / workspace with.. it says I have reached the maximum number of sheets for my account (I have not) and I can't remove the person from the sharing. Can anyone help with this? I have got a new assistant and I need to remove the old one.
Sales Pipeline Sheet information links to Project management sheet upon status change
Our company tracks sales opportunities and basic project management using Google Sheets. We would like to move this function to Smartsheets. Our basic process: (We design, fabricate and install elevator interiors) A new sales opportunity is logged into a googel sheet and given a status of "Bidding". We also input several…
SUMIF from cells with multiple values
I'm looking to pull a budget report that will help calculate the total of a cell if the criterion cell has multiple values. I have a formula that works in Excel, but doesn't seem to translate into Smartsheet. I think my issue is how to specify the correct value for the criterion. Does anyone know the best way to convert…
Ability to modify template easily and quickly.
Having been a seasoned PM for a very long time, what enticed me towards Smartsheet is the simplicity and ease of use. Having said that, I believe it is a pain in the rear to modify a template. Currently, these are the steps I have to do to modify a template: 1. Create a new project from a template. 2. Make necessary…
Multiple dropdown list driven by previous choices
How would you set up a dropdown list that is driven by the selection in a previous list. Example: column one has ten property's to choose from, column two is a list of locations specific to the property that was chosen in column one. Chosing a different property in column one changes the list to choose from in column two.…
Feature Request: Notification of lock/unlock of rows/columns to sheet owners
For the sheet owners who share sheets with admins so that they can edit locked cells, it would be good to know when the Admins are locking and unlocking the rows/columns. If they mistakenly unlock the columns, this overrides the controls put in place by the sheet owner (me). So, please create some form of notification for…
webforms
I use a web form which creates a code in the actual smartsheet, is there anyway of sending that code back to the person who raised the webform?