Best Of
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?
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
Re: Community Corner Newsletter [May 2025]
I'm such a fan of you, Max! Congratulations on achieving this new milestone. It is truly inspiring.
So many product updates, yay! 💙
Also, I relate so much with @Carson Penticuff, this Community is one of the biggest flex Smartsheet offers, and this is possible thanks to each member.
Marcela
Re: IF COUNTIF Formula help
Hello @Stacey Carrasco!
Just wanted to @mention you to ensure you don't miss Paul's response.
Cheers
Marce
Marcela