Best Of
Re: Destination sheet not appearing
Hi @Robin V.,
I assume you are trying to copy or move a row to another sheet in automation? If so, are you searching for the title of the sheet in the search bar when adding the sheet? Opening the window to connect a sheet will not automatically display a list of your available sheets as you have to enter something in the search bar.
MedaUser
Re: Will the old tagging ability on import ever return??
I have an email stating they are rolling back the upgrade. So glad to hear this news.
FGT Amanda
Re: Index Max / Children
Hi all, I found a work around in the end and did it this way. Maybe slightly long winded but helped me ensure that even if the nature of issue max score was equal to another score in the same group, I could join them in the metrics sheet. Step 1-3 are in the source sheet. Step 4 in the metrics sheet.
Step 1 - Nature of Issue Count
=COUNTIFS([Nature of Issue]:[Nature of Issue], [Nature of Issue]@row, [Site Name Helper]:[Site Name Helper], [Site Name Helper]@row)
Step 2 - Max Count for Group
=MAX(COLLECT([Nature of Issue Count]:[Nature of Issue Count], [Site Name Helper]:[Site Name Helper], [Site Name Helper]@row))
Step 3 - Most Common Nature of Issue
=IF([Nature of Issue Count]@row = [Max Count per group]@row, [Nature of Issue]@row)
Step 4 (in Metrics sheet) - Most Common Issue
=JOIN(DISTINCT(COLLECT({Most Common NoI}, {Site Name Helper}, Site@row)), " || ")
Sam Swain
Re: Rich Text Formatting in email notifications (and Update Requests)
Almost three years after the original post, four pages of comments and still no action on this? Pulleeeezzzz pulleeezzzz can you do something about this? Gravity Forms, Airtable, perhaps Monday, they all have this ability baked in.
I appreciate the boldtext.io suggestion that was sent in (page 2 of comments I think), but that's pretty hacky and forces me outside the application to make the fix.
Luke L
Re: Moving rows from one sheet to another where both have different auto numbering conventions?
@Darren Mullen I think that could work! I practiced a bit with using SUBSTITUTE() and it seems to be working as expected. Thank you!
J. Morrish
Re: May Question of the Month - Join the conversation and receive a badge
I would describe my job to a 5-year old as:
I put pictures, words, numbers, and graphs on slides. Leaders at my company want to see big line go up, or big line go down, depending on the situation. It's my job to help them understand why the line is going up or down, so we can make adjustments as a company.
Will Duplex
Upcoming Microsoft Teams Permissions Update Required
Hi Community,
*UPDATED* We will be updating our Smartsheet integration with Microsoft Teams on May 28th.
Why are we updating: The Smartsheet integration with Microsoft Teams requires our customers’ IT Admins to review and accept some permissions in order to have the add-in work. A few of these permissions will be downgraded from application-level to delegated to reduce security risk.
What this means for you: All SysAdmins will need to reauthenticate their organization’s Teams integration starting May 28, 2025 through their Azure Portal. More detailed instructions available at this help article.
If these permissions are not accepted, any new users looking to install the Smartsheet integration with Microsoft Teams will be prompted for consent and to request to have this updated permission accepted by their IT admin. Similarly, any user that tries to add a new Smartsheet tab (if the updated permissions hasn’t been accepted) will be prompted for consent and to request to have this updated permission accepted by their IT admin.
Please follow the instructions here to accept updated permissions for your Teams account on May 28, 2025.
Thanks,
The Smartsheet Product Team
Haley Patrone
Re: Bridge: Automatically backup a workspace using "Save as New"
The first workflow is correct. The child workflow would simply consist of an API module to copy the workspace. You would use a reference to the run log data for the workspace id.
If you wanted to rename it, you could include other modules before the API module to manipulate the text string. My personal preference is to us a JS module to append a date/time stamp to the end of the workspace name so that it comes out something along the lines of
"Workspace Name: yyyymmddhhmm"
// INPUT: originalName (passed into the module)
const now = new Date();
function pad(number) {
return number < 10 ? '0' + number : number;
}
const timestamp =
now.getFullYear().toString() +
pad(now.getMonth() + 1) +
pad(now.getDate()) +
pad(now.getHours()) +
pad(now.getMinutes());
const newName = originalName + ': ' + timestamp;
return newName;
Paul Newcome
Re: Dynamic View $ Formatting
Hi @Kim Stephens,
Thank you for bringing this to our attention! We've determined that decimal places being automatically added in Dynamic View is caused by a bug and our Product team is working on a resolution. We are not able to provide a time-frame on how long the resolution could take but we are doing our best in order to have this fixed as soon as possible.
Thanks,
Georgie
Georgie
Emojis in conversations now available to all users!
May, 12, 2025
We’ve added emoji reactions and the ability to include emojis in your messages to Conversations in New Views and File Library! Emojis in conversations will make it easier for our users to quickly respond and express themselves, boost engagement and streamline collaboration—no extra learning curve required. Users can use emojis to acknowledge updates, show excitement or disapproval of an idea, and quickly respond to or highlight important messages without adding extra comments. Emojis will be available in New Views only.
Environment Availability: Commercial US and Commercial EU
Plan Availability: All plans, in New Views only
Subscription Model Availability: Legacy & USM
Stay informed by Subscribing to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a weekly email with news of what's released every Tuesday.
Haley Patrone