-
Creating a Forumla
Hello, I am needing help with a formula. I have two sheets, one is a sheet where all status's are, the other is where I want the data to live. Is there a way to pull all items with the Accreditation Program and the Complete Status / the total number of items with Accreditation Program to create a % in that cell? I have it…
-
Copy to other Smartsheet when row is added or UPDATED
I have two sheets, lets say A & B, which are currently blank and will be used to gather patient information. I'm trying to copy anything entered in sheet A to sheet B including if an updates have been made (e.g. if a name is entered incorrectly in sheet A and later corrected, sheet B will be updated in the same row and not…
-
How to Update Your Community Profile Email
Around here, our team sees all kinds of questions come in about Smartsheet, but one of the most frequently asked questions we get regarding Community itself is: How do I update my Community profile email? This could be because: You got a new job or you’ve had a life change You’d like Community notifications to go to a…
-
Smartsheet Online Community Guidelines Updates - Advertising and Self-promotion
We aim to strike a balance between fostering helpful interactions and maintaining a collaborative, spam-free environment. Based on feedback from our members, we’ve updated our Smartsheet Online Community Guidelines around offering consultant services to help new consultants and current members understand best practices in…
-
Formula for Counting by Year
On my Smartsheet, I want to count the number of lots manufactured per year based on the date of manufacture. If the date is between 1/1/2023 and 12/31/2023, give me a value of "2023", and the same moving forward in 2024 and so on. I cannot figure out what the formula will be. Can someone please advise? Thank you in advance.
-
How can I get the sum of one column meeting two conditions
Trying to get multiple conditions and sum up total billable. Where Manager = John Smith in one column and Invoice Date = January in another column Getting the #UNPARSEABLE error =SUMIFS(AND(Manager:Manager, "John Smith", Invoice Date:Invoice Date, MONTH(@cell) = 1), [Billable Total]:[Billable Total])
-
[UPDATED] Community Reward Program 🏆
Hello Smartsheet Community, We value the way you support and encourage one another and want to recognize your efforts with our Community Reward Program. As you engage with the Community you'll level up and unlock rewards including swag, and access to previews and beta features. Curious? Read on to learn more about our…
-
Update your Community email address or password
Email Address in Community The online Community uses either your Smartsheet or Brandfolder account to authorize access to the Community. If you need to associate your current Community profile with a different Smartsheet or Brandfolder login, please use this form: 📝 Update Community Profile Email form Notes to consider The…
-
Getting started: Create an account
In order to ask or answer a question or create a post in Community, you must first set up an account. To get started, sign in (use the Sign In with Smartsheet button in the upper-right corner of this page).You'll use the same credentials—email and password—in the online Community that you use in Smartsheet. The first time…
-
How to score Community Points and Badges
Join in and start engaging on the Smartsheet Community platform and you’ll collect points, badges and uplevel to unlock rewards. Learn more about our New Community Reward Program Points and Badges are our way of saying thanks and recognizing you for being an active, supportive and engaged member of the Community. You’ll…
-
Welcome to the online Smartsheet Community!
https://youtu.be/NLinzZb6iwk?si=_hi2DROZxmP8bdnE This is YOUR space to connect with people around the world who are driving achievement at work with Smartsheet. We’re so excited you’re here! (Learn about the supportive and helpful culture of our community by reviewing Community Guidelines or take a look at our full site…
-
FAQs and Guidelines for posting Product Feedback Ideas
Hi Community, Welcome to the Product Feedback and Ideas space where you can help shape the future of Smartsheet! We really appreciate your feedback and will take all posts into consideration. Our product team will review top ideas and requests monthly and we'll share updates as soon as we get them. Remember: if you have a…
-
How to Implement Dynamic Dropdown among Two Sheets
A department wanted a way to take a unique list from a project column in one sheet and use that distinct listing as a dropdown for another sheet, which updated every hour. I currently run the below script from Python Anywhere on an hourly basis, and I have shared this script so that anyone else can use it as a template for…
-
Leave feedback for the Community and/or Product
Hey Smartsheet Community, Our Community team is excited to announce the launch of our Ideas & Feature Requests area of the Community! There's one topic for Smartsheet Product Feedback & Ideas and another topic for Community Platform Feedback. Here's a post with Guidelines for posting Ideas: Cheers! The Community team
-
Tips for formatting your Community posts
1 - Let others know what answer was best After someone has responded to your question with a comment, you will notice that under their comment there’s a prompt asking you, Did this answer the question? Yes . No If you click Yes, this answer will appear under a heading that says Best Answer and the member who posted that…
-
[UPDATED] Community email notifications and saving important posts
Unsubscribe or Manage Community Email Notifications In the upper-right corner of the Community, click your Profile > Account & Privacy Settings Choose Notification Preferences from the options on the right. You can subscribe to any of your Followed Topics to receive notifications for every new post in the online Community!…
-
Troubleshooting Community errors
1 - Community error message: “Permission or Domain Denied” If you receive the “Permission or Domain Denied,” error when you attempt to log in (or create a Community account for the first time), there are two possible reasons: The email address associated with the account has been warned and then blocked based on previously…
-
Create, edit, or delete a post in the Community
Log In: In order to ask or answer a question or create a post in the Smartsheet online Community, you must first set up an account (see: Getting started: Create an account). Create a Post: You can start a new Question, Discussion, or Idea by clicking New Post. Questions: only Questions can have Best Answers so choose this…
-
Smartsheet Online Community Guidelines
Welcome to the Smartsheet Community platform! The Community is a space for our Community members, customers, partners, and users to communicate and share best practices, ask questions, discuss the future of work management, and get how-to guidance from fellow users and experts. You’ll also be able to directly help shape…
-
Quick Tips and a list of Frequently Asked Questions
Quick Tips for engaging in the Community 🔎 Search before you post: Before you create a new post, search to see if your question is already out there. 💬 Be descriptive: Include screen shots and as many details as you can when asking questions or providing an answer (without exposing sensitive data). The more details you…