Best Of
Re: Update Smartsheet table with data from SQL DB
There's not great off the shelf way to do this. Also, you'll have to ensure you don't exceed any sheet limits on the amount of cells you can bring in.
Are you trying to keep the data in sync with the SQL database or just a one time import?
If you need to keep it in sync, you'll need a bridge between the SQL data base and Smartsheet.
If a one time import you can export the SQL data in CSV and import into a new sheet, or if you have Data Shuttle into an existing sheet. If you don't have Data Shuttle and want to import into an existing sheet, then you'll either need bring it in over the API or use an extension like this :
Darren Mullen
Re: How do I update a status based on 3 different approvals.
I had a typo, it is working now. Thank you for the assistance.
HRR
Re: Function() or @argument for "currently logged in user" for use in Sheet formulas
This seems like a great idea!
SSFeatures
Re: What view are you? Share your story and claim your badge
My mother use to laugh at my jokes and say "Michael is such a card!"
I don't like the Gantt view. I gantt do this, I gantt do that! I personally try to have a more positive. perspective.
Don't get board yet, my jokes only get more Grid-dy.
Sorry for my "dad jokes". Let's table this for now!
so yes, I'm a card. :-)
Michael Drayton
Re: Introduce yourself & get to know your peers!
Hi y'all!
I'm Andrew, also go by Drew. I work in training and development and have really come to take advantage of all the offerings from Smartsheet in the last year as I switched work projects. I would have to say Dashboards are my favorite function because it helps you really gain a visual understanding of your forms and reports.
I am based out of Southern California and am in fact a Disneyland lover. In my role I have the luxury of working remote with my project based out of the east coast, so I get to have the majority of the afternoon off which allows for easy trips after work.
Andrew_SmiRod273
Re: No Dropdown for the 'Enter Value' cell in my report filter/s listing "Current User"
Hi @ASU Admin,
Try setting the filter operator to "Has any of" or "Has all of". Then you should see a dropdown, for example:
I was able to select "Current User" in the dropdown.
Hope this helps!
SSFeatures
Re: 📚 New Onboarding Resource: The Smartsheet Essentials Glossary
This will come in handy. Love how everything is on a single page!
SSFeatures
Re: Hidden Columns List
I love this suggestion and have suggested it to Smartsheet for years! To expand on it further, I would love for there to not only be a multi-select option for columns that are hidden, but one that allows a selection of which columns to print/export. The print functionality hasn't improved in years. I understand that this is meant to be an online collaboration tool and don't expect significant print export functionality, but we often need to export data in a physical form and don't want to have to create a separate report every time we need to "hide" columns just to print/export.
Joe C.