Best Of
Re: Sort a Join/Collect formula?
It wouldn't be elegant, but if you added a rank column (or two, if you are worried about more than 1 row having a single date, you just need to append something to the first rank that breaks ties and then rank again) you could then add another helper column of your concatenated date/value data but now index(matched()) against the ranking so that it would be in the order that you want. Then when you do your final join(collect()) you can run it off of the ordered data instead of the unordered.

Re: Does sheet access require new users to create a smartsheet account?
Hey, @Adaora. Here a few helper links below on sharing permissions, user types, and publishing. You should be able to get done what you want to by publishing the asset to Edit By Anyone, clicking Get Link, and then choosing "Available to anyone with the link" on the Edit by Anyone - Publish Links. You should use the link Smartsheet provides under Anyone can edit this sheet at: . There is a warning below about you exposing sensitive data outside your company that you can read. Let me know if this works for you. Have a great day!
Sharing permission levels and tasks | Smartsheet Learning Center
User types | Smartsheet Learning Center
Publish a sheet, report, or dashboard | Smartsheet Learning Center

Re: [GIVEAWAY] Win a Smartsheet Certification
I can't heart and lightbulb this at the same time, so I'm using the comments to say YES! Exactly this on the value of Certification. This is the reason we changed the titles to make them value-based and recognizable. Thanks Nate!
Re: Divide By and want a max of 100%
That gave me a 27%. I am taking 22 / 6 which gives me which 367%. Most months I do not run into this on the score card, but for last month I did and do not want to go above 100%. So for the formula you gave, my 22 is the [OCME Data]@row and the 6 is the Β [Total Each Month]@row

Re: Can a summary sheet from control center act as the intake sheet for a new set of blueprints?
If you are referring to a multi-tier build, I would suggest separate intake sheets.

Re: SmartU New Offerings - Smartsheet Builder Path & more!
Rhonda, what is this about "Builder Certificate of Achievement". Please explain this. My Core App Certification is in my OTHER profile. When I started working in SS again, I was told to create another profile rather than transferring my profile. I really wish my 2 profiles could be merged

Re: Third option for Approval Workflows
Yes, we wanted to have a third option recently in a workflow we created, "Approve" "Decline" "Counter Offer". It would be nice if you can add the ability to add additional buttons in these instances and allow the workflow to have additional paths for each button.

Re: Third option for Approval Workflows
I work with a number of approval processes where the request might be sent back more than once by the approver for an update or correction by the submitter before it comes back for approval again. Currently this involves including a resubmit button that the submitter has to tick (so that the automation reboots), plus more than one "approved" and "date approved" field to try and track the progress. It works, but it's unnecessarily complicated, submitters occasionally forget to tick the box (and then it falls through the cracks), it becomes ridiculously complex to plan for more than a couple of review requests, and it's pretty easy for the system to break.
I would love a "review" option along with the "approve"/"decline" options, with that option entering into a natural return loop until approve or decline is picked.

Re: [Giveaway] Help Us Pick Our 2026 Questions of the Month!
My proposals are as follows:
- If you could design your own AI assistant, what would you want it to help you with?
- Whatβs one Smartsheet tip or trick you wish youβd known sooner?
- Whatβs one way Smartsheet has helped you grow in your career?
Re: [Giveaway] Help Us Pick Our 2026 Questions of the Month!
- What is the best advice given to you during your career?
- What are the top three traits you believe makes a great leader?
- Has Smartsheet helped you outside of your role? If so, how?
