-
Calendar App integration with Outlook
We capture many fields in the Calendar App view in addition to the ones that aren't available in the calendar view of the sheet. It would be great to integrate the exact view (with all the additional fields) into Outlook.
-
Enabling HTML Files
I work with a spreadsheet to manage communication messages and it is very common for users to attach HTML files to send marketing emails. Would it be possible to enable attachment of this file format?
-
Integrating custom HTML or JavaScript into the smartsheet dashboard.
I wanted to embed a file/URL of a custom HTML code made in order to have a dropdown menu in the dashboard and make it easier to organize data. I think it would be a great idea to be able to integrate custom HTML and JavaScript into the dashboard! Another idea is adding a feature to create a dropdown menu for convenience…
-
Export a sheet with attachments preserving the row references
For various reasons, it may be needed to export the sheet with all their attachments while preserving the knowledge of which attachment belongs to which row. Solution examples: 1) A PDF binder where a click on the link would open the attachment, which is embedded in the binder. 2) A ZIP archive containing an Excel or HTML…
-
Lock or Store Date/Value Solution without using Zapier
Hi all, I hope you're well and safe! I've developed a solution that lets you store the date or value. You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work. We'd trigger the copy-row to another sheet and get the created date/other value and then use the VLOOKUP/INDEX/MATCH to get it…
-
Average / Collect referencing another sheet and a date range
I'm trying to average the ticket ages for the current month. I’ve tried several formulas and currently I’m trying this: =IFERROR(AVG(COLLECT({SourceEOMCaseAge}, {SourceIncludeEOM}, "Yes", {SourceClosedMonth}, "April", {SourceClosedYear}, "2024")), "") The formula needs to include ticket ages where the closed date is blank,…
-
Change Cell Value workflow: Include symbols
Use case: When a new project is created, we want the initial project health to be a green symbol. The Change Cell Value workflow does not include Symbol type columns, only text/number, single select drop downs, and checkbox columns. Can we include Symbol columns in this workflow as an enhancement?
-
MAX COLLECT for blank cells
Hello all, we use a Smartsheet form for students in our internship program to submit their weekly hours worked for our instructors to track. Because the form creates a new row for each submission, I created a rollup sheet using MAX(COLLECT() to show all submissions on a single row to make it easier for our instructors.…
-
Select if multiple update request are acceptable.
Why not have a selection for multiple update request OK? We have sheets that get updated when information becomes available. But once you use the link and submit button for Update Request, you can not use it again. Our teams would like to use the Open request and submit multiple times for updates when they come available.
-
Automatically Sort Rows in Sheets
As rows get added & cell values change, it would great if we could automatically sort them in the sheets themselves instead of having to set up reports. Adding the ability to do this in a workflow would be a fantastic addition. Right now we have to do it manually.