-
COUNTIF and CONTAINS in a formula.
Hello! I am trying to count the number of times where a specific phrase is. For example, I have XX - YYYYY as my specific phrase; but some times there might be an XX - YYYYY - ZZZZ or even UUU - XX - YYYYY - ZZZZ. Is there anyway to count the amount of times that "XX - YYYYY" exists?
-
Generate Account User List - API, Power Query, Power BI, Dataflow
Sharing the solution so you won't have to navigate the challenge I just conquered! Need: Generate a list of the Smartsheet users WITHOUT having to download the report from the admin center. Solution: Power Query Assumptions: You're familiar with Power Query, Power BI, Dataflows, and how the PI works. Solve: Create a new…
-
Email address validation
We are sharing a Smartsheet with users across our company and are requesting that those users contribute different data on the Smartsheet. We have noticed that many have not responded and wondered if there was a way to confirm that a particular email is still valid? Is there a notification or something else similar to what…
-
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?