-
Column Links updated via Enhanced Global Updates
September 17, 2025 This release adds an improvement to allow column links used in Control Center blueprints to be updatable via Enhanced Global Updates, further enhancing the manageability of blueprints. In addition, column links will also be supported within templates or when sheets are copied via “Save as New”, so…
-
Is anyone available to assist me with why I cannot access my Smartsheets
I keep getting an error that I cannot access Smartsheets
-
Bridge - How to Store All Data From Multiple Child Runs For Comparison
Hello Bridge folks! Scenario: I’m calling an API that paginates its response data by providing a “next_page_token”. I use this in another call to get the second page of the response data. I’m using a child workflow to run once to get the first page of data, determine if there is a next_page_token, and if there is, call…
-
Dynamic View plan-level asset ownership now generally available!
September 02, 2025 Introducing Dynamic View plan-level asset ownership, designed to improve reliability for end users and reduce manual ownership transfer work for System Admins. Sheet-backed views are no longer tied to a single user and are instead owned at the plan level, ensuring they continue to work as expected…
-
Count Distinct Using a Text Column with Values Separated by Commas
Hello! I have a column with a list of values separated by commas. I am looking to count the number of values separated by commas and eliminate duplicates. I have tried creating a helper column that converts the values to a multiselect, but I can't figure out the =COUNT(DISTINCT formula from there. Here is a screenshot…
-
MM/DD/YYYY Formula vs. TODAY
I am new to formulas and looking for a way to populate the "How Many Years?" column on my sheet vs. today's date. Thank you in advance!
-
x-sheet reference - trigger for automations
Trying to trigger an automation that is not working b/c the source column is a x-sheet reference value. I understand tht x-sheet references cannot be the trigger for an automation to run on the destination sheet. I've added a helper column on the destination sheet that is a formula column that references the column that…
-
SUMIFS with wildcard (*)
Hello, I am trying to use the sumifs formula for summing values in one column based on the first two letters in another column. This formula is not working =SUMIFS([Total Invoiced]:[Total Invoiced], [Google Location ID]:[Google Location ID], "CA*") I have tried exchanging the criteria column at the beginning as well, and…
-
Need Formula for Subtracting Order Quantities from Inventory Quantities
Hi! What formula would I use in Smartsheet to automatically subtract a quantity from one sheet based on what is submitted in another sheet? I have one sheet that is where we will manage the "orders submitted" and on that sheet is different columns for different items that can be ordered and the quantities requested for…
-
Trouble with an IF formula
Hello! I'm having trouble with an IF formula (combined with two COUNTIFS formulas as results) where I'm trying to count specific rows in a sheet based on certain criteria. The IF statement is to count status if the quarter is current or before, otherwise exclude status if the quarter is in the future. Both COUNTIFS…