Best Of
Re: Celebrating the Community with Smartsheet Swag!
This photo makes me miss ENGAGE!
Nicole Tellez
Re: What does it look like to operate at your peak? 💭 Join the conversation
When I operate at my peak I am well rested, hyper focused, alert, and in sync with my team. I am also busy but not overwhelmed and everything is clicking. Challenges are overcome and not roadblocks. Positive attitude and outlook. This doesn't happen often but is something I strive for every day.
Steven Sawyer
Re: What does it look like to operate at your peak? 💭 Join the conversation
I operate at peak human when I have balance in my life across the major categories that I constantly monitor: Mental and Physical. These broad categories deep dive one click down into subcategories of work, family, friends, health, etc. I'm a person who tends to go real hard and fast in one category and then lets the others slide, and the repercussions aren't, well, awesome! 🤣 So I'm constantly taking inventory of how I am I feeling and what parts of my life do I need to tend to? Always a work in progress.
Alison C.
DataMesh within the same sheet to copy cells from one column to another
Up until today I've restricted my understanding of datamesh to copying values from sheet to sheet. However, I just discovered today that you can use it WITHIN a sheet! What does this solve?
If you ever need to copy a value from column A to column B, but do not want to use a formula, then this process is perfect. It also solves having to use data shuttle and excel to export/import a value back into the sheet.
For example, we have a backend process that generates a code for each line item and puts it in a column called [Generated Code]. The code is a concatenation of several things. We have another column called [Code] that is free text. The user has the option of putting something in that field, and most of the time they just forget. The data mesh trick copies the value from [Generated Code] to [Code] so the user never has to worry about it.
If in the future they want/need to make a manual change to the code, they are free to do that. I have data mesh set up to not overwrite values.
A second example has to do with start/end dates of customer events. Most of the time people forget to include an event's end date, and most of our events are 1 day events. This trick copies the start date to end date field. Obviously a formula cannot work here, because you could never have multiday events (without a helper field). This way we assume an empty end date means it's a one date event.
Just thought I'd pass this along, I hope it helps at least one other person.
johngraham78
Re: User invitation automatically declines
Hey everyone, we have an update!
Based on the experience this week with email security software, our Engineering team has implemented a temporary change for how our Invite emails function:
When the either the Decline or Accept options are selected in an invitation email, this link will redirect to the Smartsheet login page (instead of immediately taking the selected action).
- If the recipient has a Smartsheet account, they will need to log in to submit a response from within the application.
- If the recipient does not have a Smartsheet account, they will need to set a password. To set a password, they will need to select the Reset Password link and create a password that way.
Please re-send invitations to any of your users that show as Declined in your Admin Center and they should now be able to go directly to Smartsheet to Accept or Decline.
Thank you,
Genevieve
Genevieve P.
Re: November Question of the Month 💭 Join the conversation and receive a badge
I am most thankful for the automation feature.
Deowens
Re: Innovations, swag & more: Community Corner Newsletter [November 2023]
So many things:
1) Love this picture of you @Arsineh, Travel Queen
2) Any advice @Sing C provides, I listen to
3) @Sara_Cook ready to hit the "Take On Me" high note with me in our next Overachiever meetup? 😉
Alison C.
Re: November Question of the Month 💭 Join the conversation and receive a badge
I am thankful for the Smartsheet's Help & Learning section. Whenever I'm stuck, I know I can go hear and find what I'm looking for. Also thankful for Smartsheet investing in tools like Help & Learning, the community, and certifications to grow our knowledge and keep us connected as a community.
khickman
"Bulk" archive sheets/folders/workspaces
Provide a way to bulk archive assets and automatically remove all sharing, deactivate workflows, etc. (similar to Control Center). Current method of manually removing sharing and deactivating workflows on thousands of sheets is too time consuming.
Ami Veltrie
Re: November Question of the Month 💭 Join the conversation and receive a badge
I am most thankful for reports. The easiest way for me to work with real-time data that are being referenced from a slew of sheets. The ease of seeing all the data served in one single view is extremely helpful when I need to report (no pun-intended) on projects that don't have one source of truth sheet.
I ❤️ reports and most importantly I ❤️ Smartsheet for offering this feature.
Maxwell G.