-
COUNT IF + NOT CONTAIN
I am using the formula below and the NOT CONTAIN is not working. Could anyone help? COUNTIFS({Spreadsheet_1 Range 3}, "John Smith", {Spreadsheet_1 Range 1}, "In Progress", {2023 Spreadsheet_1 Range 2}, NOT(CONTAINS(@cell, Maintenance))
-
Automations: include attachments
When selecting attachments for an Automation Workflow, we should have the option to include all the attachments in the notification email instead of sending only the last attachment if it was attached after the last save of the sheet.
-
Attach an existing Dynamic View to a sheet programmatically
I know there is no API for Dynamic Views yet, but I'm looking into building some automation for a client and wonder if there is a way to programmatically assign an existing Dynamic View to a new sheet. It doesn't look like when you copy a sheet and create a new one via API, the Dynamic View associated with that original…
-
IF(OR) formula - add AND qualifier for all
I have an IF(OR) formula that is working exactly the way I want it to. I want it to check a box if one of three column criteria is met, which it is doing correctly, using the below formula: =IF(OR([Column A]@row = "Choice1", [Column B]@row = "Choice2", [Column C]@row = 1)), 1 I want to add a second condition that applies…
-
Smartsheet Connector error: Smartsheet unexpected REST API error has occurred.
Hello! My org uses Smartsheet Connector to connect a series of sheets to Salesforce. We get this error quite often and I don't know how to solve it: Smartsheet Connector error: Smartsheet unexpected REST API error has occurred. Could someone take a look and potentially help answer why this is happening?
-
Max Row Within a Group
Hello, I have sheet that gets a row added every time someone add a response. The example shown is a simplified version. Each response is associated with a Group of combined columns (1 company + 1 ticket) - See column named "Join". Users can add a new response for each Group over and over. Each time they add a row, the…
-
Formula Counting blank values W/ =COUNT(DISTINCT(COLLECT
I'm trying to collect data from other sheet and COUNT with DISTINCT. EXAMPLE 1: =COUNT(DISTINCT(COLLECT({NAM-SERIAL}, {NAM-RTS-FW}, [FW11 2024]76, {NAM-FW-OFF}, <>""))) EXAMPLE 2: =COUNT(DISTINCT(COLLECT({NAM-SERIAL}, {NAM-RTS-FW}, "11", {NAM-FW-OFF}, <>""))) EXAMPLE 3: =COUNT(DISTINCT(COLLECT({NAM-SERIAL}, {NAM-RTS-FW},…
-
I have dashboard charts using reports and "<unknown sheet>" appears in them
Is there a way around this? It is appearing in the Sheet Name list and just looks a bit unprofessional. My reports do use summary but not group.
-
Add ScribeHow iframe embed codes to dashboard web widget domains
Our organization has started using ScribeHow, and it is awesome! We are saving tons of time on creating instructional documents. We would love to be able to embed those "scribes" in Smartsheet dashboards, but the domain isn't included in those that can be embedded in a web content widget. scribehow.com
-
How to reference Sheet Summary cell in the text of an automation?
I've been usign columns references in the text of my automations messages a while now. It looks like that. The text is in french but you can see the symbols used. Bonjour {{Fournisseur}} Voici la confirmation de commande pour le projet {{Projet}}. La date de début est le {{Date de début}} La date de fin est le {{Date de…