Best Of
Copy specific cells to another sheet
Hi ,
Is it possible with automation function to copy specific cells from choice to another sheet with out copying the complete row with all columns
For example To cop cells in column A, B and F to another sheet without copying middle cloumns D, E etc
Thank you
Waleed
Meet Nick Burrus, our December Member Spotlight! 🎉
Stop what you’re doing and come meet @Nick Burrus, Community Champion and our December Member Spotlight!
St Nicholas Burrus is the Business Process Outsourcing (BPO) Production and Project Manager at UBEO Business Services and lives in California.
Several years ago, Nick worked for a digitization company focused on helping companies transition from paper records to digital records. They began using Smartsheet for internal processes, and soon, Nick was taking classes and happily experimenting until he became the “de facto Smartsheet guru” on the engineering team.
“From there, I’ve just kept practicing, reading the Community forums when stumped, sharing my own work-arounds, and collaborating with others on how to accomplish something unique,” he explains.
Today at UBEO, Nick is a huge fan of cross-sheet references in formulas. He recently built a solution that allows employees to enter the work they’ve done for the day, including details, for tracking and analytics. Dashboards then automatically use references to fill out manifests, showing clients how much of a project is done and providing a live view of progress.
“One of my favorite things about the Community is how people use formulas in new ways,” Nick says. “Did you know you could do algebra with time stamps by stacking LEN and LEFT/RIGHT formulas? Formula stacking is insane and I absolutely love it. With Smartsheet, you can pull off things that are seemingly impossible in other platforms.”
As a Community Champion, Nick spends his time participating in virtual events and opportunities, and he advises fellow Community Members to jump in when they have the bandwidth. “Learn the tips and tricks of Community Champions, Overachievers, and more, and you’re bound to become the champion at your organization,” he says.
Nick recently adopted a dog and loves having her as his frequent companion. As someone who has had a heart transplant, he enjoys volunteering at transplant events as a guest speaker and judge.
Thank you for all you do, Nick!
Alison C.
Can dynamic view's detail panel require an attachment upload?
We are using dynamic views for our product orders with vendors. When the product is complete, we require them to upload completion photos, a BOL, and shipping documentation. We have run into the issue where the vendor forgets to upload certain documents. Can we make attachments required? Is there a way that we can categorize the attachments based on type?
Rachel Beck
Re: December Question of the Month 💭 Join the conversation and receive a badge
I am a proud to have accomplished stepping out of my comfort zone and attending my 1st Smartsheet User Group this year in Chicago! Can't wait to attend more and meet more Smartsheet "Nerds" 😎
Happy Holidays to All!!!!🎇
Re: Dynamic View Logic should behave like Conditional Form Logic (aka "live")
This is a MUST HAVE feature for Dynamic View forms to be usable.
Robert Newton
Re: Countifs with Distinct?
Thanks Everyone,
Based on the samples provided, I was able to get my scenario solved by using a combination of COUNT, DISTINCT, and COLLECT.
It ended up looking like this:
=COUNT(DISTINCT(COLLECT({Email}, {Geo}, ="AMER")))
Thanks.
David Bright
Re: Option to Not Include Sheet Link on Notifications
I know you can use {{ }} to fill in specific field info, but it would be great to send the filed info in the row or vertical layout WITHOUT having the sheet link in the email.
Mihaela K
Re: Send Dashboard via email - manually and automated workflow
Hi Katie,
Unfortunately there had not been any insight on a possible date. The best thing folks can do is continue voting this up as much as possible. The more votes, the more of a priority this will get and I would suspect the sooner we will see it. Please have as many colleagues and contacts as you know vote this up. 🙂
I was just at Engage 2023 and this was not a feature they highlighted as coming in the next couple of releases, so I fear it remains at least 6 months out.
TomG
Share to Domain / All / Enterprise / Everyone
The ability to share to everyone in your account possibly using Domain (similar to Dynamic View).
Perhaps only allow System Admin to set this up for security.
We have an Enterprise Plan and I was looking for a method to share a sheet to everyone as viewer. We have a lot of people and creating and maintaining a group for them is too cumbersome. Publishing doesn't work, they need to be able to search the data. Dynamic View doesn't work because you can't search. Filtering is too cumbersome for this application.
KarinR
Re: Nominate Peak Humans & get a badge!
I would like to nominate my fellow 2023 Community Created Template Winners!! @Lauren Dominique & Nicholas Miron.
And the runner ups @TWO21 @DesireeJones @MCorbin
