Best Of
Re: Can I share a folder within a workspace to someone without having to share the whole workspace?
Dear Smartsheet team,
I'm wondering if Alicia's suggestion has been put in place in Smartsheet now? Thank you.
Is it possible to share one folder within a workspace with someone, without sharing the whole workspace with them? I want them to see only files in their folder, but not everyone else's folders within the workspace.

Re: Sharing a folder in a workspace
scratch that last comment, I realized afterward you cannot create a workspace within a workspace.
I think my only (simple) option will be to create a workspace for each new customer separately. Is there a good way to archive a workspace? I am looking to declutter when a project closes so we don't have a pile up of old project workspaces hanging out there.

Re: How to ignore #DIVIDE BY ZERO in SUM function?
You are getting a blank because of your iferror() function - sum() will throw an error if you have an error in the range it is summing, so it is showing the single space you are calling for.
The only way I know of to fix it is to modify the template so that the formulas in Annual Cost (Original) include an iferror() function directly, so that lines that used to show "#Divide by zero" are now blank. Then you sheet summary will work.

Re: Provide API Access to Upgrade or Downgrade Users under User Subscription Model (USM)
Firmly agreed here, we were recently switched to USM (unfortunately) as well. The "update" has broken our automated processes as well and as a bonus, has given us more work.
Color me surprised that a company acquired by private equity starts providing worse service for more money.
The frustration is doubled because the error message points you to things that don't exist within current API documentation.
"User subscription updates (upgrade/downgrade) cannot be performed through this method. Please use the bulk upgrade/downgrade API"
Contrary to prior history with Smartsheet, this new model feels like a half baked cash grab that wasn't properly planned or executed, which is more or less in line with what we expect from private equity. Hate to see it; we'll definitely be pushing to move away from Smartsheet ASAP.

Re: March Question of the Month - Join the conversation and receive a badge
I'd like to improve my skills as a solution architect to better align people and processes.
Re: March Question of the Month - Join the conversation and receive a badge
Being able to find the information I need from the hundreds of notes I take. AI helps with "taking" the notes, but gleaning from that bounty of facts is an on going quest.

Re: March Question of the Month - Join the conversation and receive a badge
My one skill, making it Smartsheet related, is in the competency of setting up Control Center. I'll be chasing that certification here soon and I'm looking forward to being on the other side of the exam!

Re: March Question of the Month - Join the conversation and receive a badge
I'd like to improve my ability to transition. When I'm focusing in on things, I find it challenging to change over to something else promptly. #continuousimprovementopportunity

Form Logic calling another form
Is it possible for a form to call another form based on a logic selection

Re: Removing duplicate rows in a sheet
nice to have a feature to flag duplicate values in column
