Best Of
Re: Send Dashboard via email - manually and automated workflow
Yea from a technical perspective this is a challenging feature to implement, and it's something that I've been playing around with adding into SSFeatures. But I'm hesitant to work on it if the Smartsheet team is actively working on this feature.
There are so many widgets, with lots of different customization options, and each of those would need to be explicitly rendered properly while sending out the email. Definitely a lot of work!
Thanks @TomG for keeping this thread updated!
SSFeatures
Re: How exactly will the new user-subscription / True-Up model affect my business?
Hi @kowal
Yes all my customers will have their own domains only. Thanks a ton for providing this valuable insight!
zealvert
Re: Table view initial release is now generally available for all customers!
I figured out how to sort multiple columns with different directions in the Table view. I hope this helps anybody else who was struggling like I was.
- Select 1 or more columns.
- You can hold "CTRL" then click to select another column without deselecting the first column.
- Then right click one of the columns.
- Then hit "Sort ascending" or "Sort descending".
This forces all of the columns to sort in the same direction (ascending or descending).
5. Now you can directly click the arrow under the column name to change the sort direction for that specific column.
Now you can sort your columns, and choose which direction you want each one to be sorted.
SSFeatures
Re: Formula for RAG rating based on status and dates
@kowal @Cheryl C thank you both! The formula works but how would i make it so it shows in the coloured dots?
Update: all good I figured i just had to edit the format of the column. Thank you!
Carmen H
Re: ESRI Integration: Does anyone have an existing solution for ESRI↔Smartsheet? (GIS/ArcGIS)
Hi @NeilKY,
It looks like the Skyway integration may be the only existing integration for ESRI and Smartsheet. The alternative would be to use the API, but I understand that you’re looking for something that’s already set up. I’d recommend adding your vote to the following product idea and adding a comment as to how this would help you:
I also found this blog post in the ESRI Community which may be useful if you haven’t already come across it: Updating ArcGIS Online hosted feature layer with Smartsheets using ArcGIS API for Python
Hope that helps a bit!
Georgie
Georgie
Re: From ESRI GIS to Smartsheet
@NeilKY Unfortunately, we did not. I'm thinking about taking GIS data from SQL into Smartsheet using the ODBC connector, but have not tried that yet.
ljkeefe1
Re: What equation should I use for a floating Quarterly budget total
Not sure how others solve for this type of thing, but my solution has been to create what I call relative date columns that simply look at a date field and determine if it is "This QTR", "Last QTR" or "Out of Range" (I don't need future for what i'm reporting, but it would be simple to add). They are just nested IF statements. I do this for Year, QTR, Month and Week, and will then use a combination of filters in a report to get the data I want (e.g. "This Year" and "This QTR"). Sounds like you could add these columns to your metadata sheet and then report against that. Hope that helps.
Adam Murphy
