-
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…
-
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…
-
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 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…
-
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…
-
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])
-
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…
-
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