Best Of
Partner with FiveTran to build a Smartsheet grid connector
I've used client-based BI tools to extract Smartsheet data via ODBC, but there do not seem to be many (any?) delivered cloud-based solutions. I'm not too interested in programming and maintaining anything myself with the APIs. FiveTran is one of the market leaders and does this for a living. I'd love to see a team-up to build a connector for easy grid extraction and loading into our data warehouse. With an option for full-sheet loading (purge & replace) or leveraging the sheets special modified date column for change data capture.

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.
Also could there be built in instructions that accompany the email sent through automation? Like click on the blue open to see the next instruction.

Re: Dashboard Help- COUNTIFS, Checkboxes and Hierarchy
There are two ways to do this, the formula illustrated by @AngB789 above, or if you are uncomfortable with formulas, you can also always set up a report that pulls from this sheet like so:
- Generate new row report (I usually have mine in a folder labeled "Charts"
- Select this sheet as the source sheet
- Select the "Closed?" column in columns
- Filter the "Level" column to equals 2
- Group the report by "Closed?" and collapse the group (bottom left of the group dropdown)
- Count the "Closed?" column under summary
- Select this report when generating a new pie chart
This option is also better if you want to select the pie chart (option when clicked open source), and see what row falls in each category of the pie chart; however if you are comfortable with formulas and don't really care about what row pertains to the pie wedge, I suggest going with AngB's way and create a collapsible summary row at the top for charts.
Edit to add as I just saw your additional comment, you can add/change the filters to make sure it contains only rows that are under specific primary columns (whether that is determined by an additional column with dropdown tags or if primary CONTAINS certain phrases)

Folders within row attachments
Sometimes a job has many different types of documentation, it would be nice to not have everything all jumbled together just because it pertains to the same row (job). Organization within each Rows attachments.

Relationships between tables
I would like to be able to create relationships (parent/child, 1:N, 1:1, N:1) so say for example 1 employee registered on table A could have multiple assignments in Table B

Re: Enable Document Generation into Microsoft Word, Google Docs, or HTML
Hi @Mounika -- I'm sorry, but I can't help you. My post above is a request for an enhancement to Smartsheet to enable to do what you are asking for.

Gantt hour-by-hour
Dear Smartsheet team,
We have been using Smartsheet for many years and have found one major area our administrative efforts are redundant is copying over tasks into our Calendar to manage hour-by-hour dependencies.
In an ideal scenario our Outlook, Google Calendar, and or Apple Calendars would all sync to the SmartSheet project and reflect the hour-by-hour implications of larger-scope project changes.
Is there a roadmap for this to be included?
Many thanks from Toronto.

Re: Please Allow Multiple Admins for DataMesh
I strongly agree with this. I cannot find a way to view my teammate's data mesh configurations. We should be able to share with other team member's as back-up and have the ability to view or edit when given permission. The way it is locked down right now doesn't seem to be the best business practice.

Re: Multiple Owners to add users to Smartsheet Groups
Seconding all that has been said about making this a feature. Very inefficient otherwise. Please make this happen!

Re: Please let Smartsheet work with time
Hello,
I was hoping that a time selection option for the field settings in the sheets. Currently, there is a current date/time stamp function that captures the time when the row was created, but being able to select a specific time would be beneficial in organizing workloads
