-
Smartsheet Merge and Transpose
Hello, I have two sheets. One sheet is a list of items to be offered at a charity auction with a different row for each item and columns with specific (Item number, donor, minimum bid, winning bidder number, cost etc). The 2nd sheet is a list of the bidders with a sum of the total that they have bid (bidder number, count…
-
Tracking Data / Shared Sheet
Hi! I'm really enjoying Smartsheet and glad we decided to go down the path of subscribing. While I was getting certified I found so many neat features and my mind just filled with all the things I could probably use various aspects of Smartsheet to accomplish. I ran into a limitation in my own scope that I'm sure…
-
Alerts & Action notification
Hello, I am trying to modify the Alert&Action notification which I receive when someone updates the sheet via form. This sheet has around 50 columns which need to be updated, and form updates them regularly. However, I would like to receive a short summary of the 15 fields of most interest but it seems that notification…
-
Automated feedback using forms
Hi there, After we have a speaker attend an event and deliver a speech we have prepared, we would like to automatically send them a form to fill out asking what worked well, what needs further work etc as many speeches are different versions of similar material. I can link the cells from the original event to a new sheet…
-
email lookup
hi, Is there a way that if I choose a name from a drop down box in one column it will show the appropriate email address in another column? regards, Mark
-
GMAIL and Smartsheet Integration
Good afternoon Is there a reason why we are not able to fill out some of our columns on the Samrthseet Side bar ? It says "Please edit the following columns in Smartsheet" which requires an added step....... Thank you
-
Vertical Layout for Alerts
Is there a way for us to control/customize the format of the alerts we receive between vertical or horizontal? We prefer the vertical formatting over the horizontal as it is easier to read and the formatting carries when we have to forward the email. I have several sheets where when I first set-up the alerts, they came in…
-
Adding New Items During Update Request
I have a report page where I've been testing the "Update Request" feature through a custom form. It works well for updating existing information, but is there a way to also add new line items with that request? For example: If I am sending an "Update Request" for a user to review a list of existing fruits and vegetables…
-
How can I include an attachment shared to the sheet in requests for approval?
I am using a sheet to manage a client contract approval process. I am imagining attaching the draft contract to the sheet itself or to a single row towards the top of the sheet. I have several approvers listed below in separate rows and need to send out requests for approval with the draft contract attached. Is there any…
-
Changing Order of Columns included in Alerts
I've set-up an alert that only shows some of the columns within a sheet. Is there a way to change the order of how the columns appear in an alert without changing the order of columns in the actual sheet? Thanks! Glenda