-
Relationship Report - collect multiple sheets' data to one row based on an ID
Come up with a relationship type set up across different sheets in Smartsheet like how MS Access does with their tables. This will allow users to easily create reports using different sheets without having to have the sheets all mirror one another just for the information to flow properly. You can set up relationships inβ¦
-
Data Shuttle: update a checkbox in the source sheet to indicate success
Currently, Data Shuttle efficiently migrates data from Smartsheet to SharePoint, OneDrive, GoogleDrive, Box, & as a Smartsheet Attachment. This Providing a seamless integration between the two platforms. However, one aspect that could enhance user experience and workflow efficiency is the ability for Data Shuttle toβ¦
-
Select which columns to copy or move from one sheet to another
As part of the automation it is possible to copy or move a row from a source sheet to a destinatio0n sheet. At this point all columns are copied/moved, and if a column do not exist it will be created in the source sheet. The request for this improvement, is to allow the admin or owner of a sheet to select which columnsβ¦
-
PROPER Function
Hi! I wanted to submit a feature request to add to Smartsheet. I organize a lot of documents that are displayed in all caps [Ex. PLEASE SUBMIT ADDITIONAL NEEDED DOCUMENTS]. I have noticed there is not an action/formula available that changes the text to PROPER like in excel [Ex. Please Submit Additional Needed Documents].β¦
-
Numerical Sorting
Smartsheet does not sort properly by numbers when you get above 9. Currently, it'll sort 1, 10, 11, 2, 3, 4, 5, 6, 7, 8, 9 rather than 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 and the only way to fix it right now is by adding a character in front of the ones below 10.
-
I need something different than the update request
I use Smartsheet to process requests and want to be able to send back a message, some information in columns and an attachment. I use update request, but don't really need an update. I also wish the message box was a little easier to work with. It's pretty small and I usually have to scroll to type in a complete message.β¦
-
IDEA: Populate Available Field Names After Typing Double Curly Brackets {{
When I create custom messages in Automations, such as approval emails, I'd LOVE to have the system give me a list of possible field names to use after I type in the double curly brackets '{{' This would work exactly like Dropdown lists do, with their pre-populated lists.. I'm certain there are other locations where thisβ¦
-
Sort Report by the Summary result
I am having a report grouped by region and summarized by numbers of process per region. it's only sorted alphabetical by region not possible to be sorted by summary numbers. Easy feature appreciate if it could be existed soon. Thanks team, Shorouk Helmy
-
Copying a Form from 1 sheet to the next
I am not sure if this is the correction location to submit this "Enhancement" request. I have a FORM that I have created in multiple (6) sheets that use the same columns, fields, data; and now I have to modify every single form, in each sheet (6 times). I would like the option to modify it in 1 sheet, and then copy itβ¦
-
Deactivate form after set # of entries/submissions OR by date
It would be a great thing to be able to specify that a form be made inactive after a set # of entries. For example, my company is sending out an email with a link to a form created to gather demographic information on the individuals. The first 40 submissions are eligible for a 'free lunch' and we don't want to continueβ¦