Best Of
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
Re: Enable Clickable Hyperinks in Smartsheet Forms (Android Mobile App)
Hi @AliceVBH, thanks for clarifying!
This is not expected - hyperlinks in forms should work whether you are on an Android or iOS. It's very helpful that 6 users have voted on this post to show it happens across more than one device!
@FreyaW @B.Wats @cschoenfeld @Monique Odom-Stearn @Hiroka
***Please create support tickets showing the behaviour.
Support will need the same information requested above, along with the Form URL (if you're willing to share) or a screen capture showing where the hyperlink should be, and what it looks like in your Androids. They can then escalate this and troubleshoot it in a private channel where you can share these details.
Thank you!
Genevieve
Genevieve P.
Re: Summary report, grouping data
In a standard report you can use the GROUP function to group by Country and also by Import/Export and by Quarter. You can then use the SUMMARIZE function to automatically average the 2 green columns per grouping. Would that work?
Adam Murphy
Re: How to Create a weekly report and make it automatically go out to stakeholders at a specified time e
Kowal,
Thank you for the information. It's just what I needed.
Respectfully,
Augie
Augie
Re: IF COUNTIF Formula help
Getting the formula to only check a single box for each school involves a helper column. Auto-number (called "Auto" in this example) with no special formatting. Then the formula for the checkbox changes to:
=IF(COUNTIFS([High School]:[High School], @cell = [High School]@row, Auto:Auto, @cell <= Auto@row) = 1, 1)
Or in a sheet summary field or a separate sheet (updated with cross sheet references of course):
=COUNT(DISTINCT(COLLECT([High School]:[High School], [High School]:[High School], @cell <> "")))
Paul Newcome
Re: Community Corner Newsletter [May 2025]
Hi Max,
Congratulations on your qualification! I'm happy for Spring too. Winter stuck around way too long this year. Thanks for another great update! Lots to peruse and explore.
Ray Lindstrom