-
How can I Data Shuttle within Smartsheet?
I am only seeing options to shuttle information from Smartsheet to external targets like MS Teams and my personal folders. I would like to grab information that fits a specific criteria from one sheet and move it to another within Smartsheet. Please help
-
Donut View - Legend loses it color if value drops to zero
Hi Team, Can you please confirm why is a Donut graph now able to retain the Legends which it is mapped to unlike a Bar chart. Problem occurs when one of the legend values drops to Zero and later if there is a value, the legend does not retain the color it was originally assigned to. Let me know if you need more details.
-
Is there a way to put a display name on a hyperlink in the Form Description?
Is this possible? I see it was asked quite a few years back and a couple people added it as an enhancement, just wanted to see if it was ever implemented?
-
How to save formulae for future reference incase the sheets need to be rebuild
Hi Team Can you suggest the best practice for saving all of the formulas used on the sheet. I have though saved copies of the sheets in a separate folder for reference but if there a way to download these SS with formulas in excel or word or any other format.
-
option is not blank + assigned to
I'm trying to count the number of cells in a column "CPS Has Referred Member To:" that are not blank, by individuals identified in "Assigned To" in a sheet summary
-
Unable to Sort By Date if "Formula"
I have a column that is calculated based on a specific number of days. I would like to sort those so the oldest is first etc. However the column heading is not showing up in the "sort" drop down as an option.
-
How to display unique dates from a sheet (source) to another sheet
Hi, I tried searching on this topic, and found a formula that worked for someone else. =IFERROR(INDEX(DISTINCT(COLLECT({Column 1}, {Column 1}, AND(ISDATE(@cell), @cell >= TODAY(-45)))), [Row #]@row), "") While I am trying to figure how to use it for my needs. My sheet has column name "Visit_Date" with listing of dates My…
-
Please enable us to select multiple contacts when sharing (was avialable a year or so ago)
About a year or so ago, if you wanted to share anything in Smartsheet, you had the ability to bring up your entire contact list or type a keyword, you would then be able to select multiple contacts to share with the same customize message. Please bring that back. It is a much-missed function. Thank you!
-
How to transform a Multi-select dropdown into multiple rows
Hello, I am using an intake form to capture the preferences of the submitter in a "Choices" column, there are over 100 available options in that column. I'd like to be able to group and sort these in a Report, however this is not possible to do with a Multi-Select Dropdown value. As such, I'd like to transform the…
-
Data Shuttle Upload: To use one-drive shared file as a Source Sheet
Hi all, I am using data shuttle, to upload the data from Excel into the Smartsheet sheet, and within the Upload workflow I am not able to find the find the shared folders where the source file is existing. In order to upload the shared file should I create my own folder and dump the source sheet into that? FYI: I am able…