-
September Question of the Month 💭 Join the conversation and receive a badge
Hi everyone, We're ready to kick off September with a new question and opportunity for you to earn some badges and points while getting to know your peers! If you had your own talk show, who would your first guest be and why? Could be anyone, a celebrity, politician or historical figure just to name a few . Get creative!…
-
[RECAP] ENGAGE 2023: Potential Unlocked
Last week, thousands of you, along with Smartsheet staff came together for our annual conference, ENGAGE: Potential Unlocked to learn, connect and have fun doing it. Here are just a few highlights from the week: Community Champions & Overachievers took the stage: These program members not only came together during the…
-
New! TIME function for formulas
Hey Community, Some of you may have noticed a new function in our Functions List last week… Introducing the TIME Function! This returns the time of day in 12- or 24-hour format from a given set of values. Syntax TIME(time_value, [ format ], [ precision ]) time_value — The value to create time with. Must be provided as a…
-
Don't miss our ENGAGE Women in IT Luncheon event!
We are thrilled to host our first Women in IT Luncheon hosted by Smartsheet leadership! This event, spotlighting women and gender minorities in IT, is designed to kick off ENGAGE while fostering an environment of diversity, equity, and inclusivity within the tech industry. Event details: Tuesday, Sept. 20 Time: 11:30 a.m.…
-
Smartsheet Travel Diaries Bonus Giveaway - Win a Travel Kit!
Today, we bring you part 2 of the Smartsheet Travel Diaries. We’re giving away a Smartsheet travel kit, perfect to take on all of your adventures! How to participate Check out your peers’ amazing submissions and show support to your favorites by using the Vote up and Awesome icon reactions, and you’ll be entered into a…
-
Presenting The Official ENGAGE Playlist!
Hey Smartsheet Community, We’re over the moon to present the Official ENGAGE playlist that we made together 🥳 Your enthusiasm for the playlist has been epic. We received over a 100 song suggestions, and an incredible solution made by Overachiever @Kyle Chipman. Calling you awesome feels like an understatement 🤯 Time to…
-
Ready, set, share your solution! 🚀 Showcase your skills for a chance to win unique prizes.
Hello Community Members, It's that time of year again and we are thrilled to bring you the Community Created Template Showcase - a unique opportunity to show off your ingenuity and creativity! Submit a solution for a chance to win unique prizes, your very own customer story, and to have your solution published as a…
-
ENGAGE 23 Logbook - Share & connect!
Hey there, ENGAGE 23 attendees! Presenting the ENGAGE 23 Logbook — your one-stop place to introduce yourself, share photos & selfies, document your favorite experiences, and connect with your peers at the event. Explore the ENGAGE activities to your heart’s content, attend sessions, meet people, and save your best memories…
-
✨ Smartsheet ENGAGE 2023 delivers style, efficiency, and scale
We’ve been sharing updates from ENGAGE and we couldn’t be more excited to share some of the innovations unveiled during the keynote. Get the complete list by visiting the recent blog post by Ben Canning, SVP of Product Management. Here are some highlights on the innovations that will help you better plan, do, and scale…
-
Spot Smartsheet in the Wild! Operate at Peak Human
Hi Community Members, During ENGAGE, attendees will be exploring Seattle and snapping photos with Smartsheet campaign ads positioned around the city — and you can join in too if you live in the Seattle or Chicago area by snaping a photo and uploading it to the comments below. ENGAGE Attendees You could wait to be surprised…
-
Quality controlling data entry to prevent duplicates
I have a vendor database with over 1,000 unique vendors and am looking for a way to quality control new entries to avoid duplicates in a VENDOR NAME column (note that there is a separate VENDOR ID # column). One way of doing this seems to be through formatting the VENDOR NAME column as a dropdown while NOT restricting to…
-
Count Active assignments by individual
=COUNTIFS([Assigned To]:[Assigned To], ("Name"))AND [Request Status];[Request Status], is one of "In Progress", "Submitted", "Completed") My countifs statement works by name but I want to further refine this by [Request Status];[Request Status], is one of "In Progress", "Submitted", "Completed")
-
Using COUNTIFS to count number of occurrences within two different sheets = UNPARSEABLE
Hello - This is my first time using this community. I am trying count across two sheets to count the number of times a name is present in a column. They could be contained in both or just one sheet. My formula is continually wrong and from experience I know that it is likely something little that I am missing. Here is the…
-
COUNTIFS formula returns zero, confirmed should have positive value
Hello - I created this formula and it does not error out but it does not correctly count the field what did I do wrong? =COUNTIFS({Polaris minus CSC Creator1}, =Creator@row, {Polaris minus CSC Substatus}, "Open-Update Needed" + COUNTIFS({Polaris minus CSC Creator1}, =Creator@row, {Polaris minus CSC Substatus},…
-
Setting up a weekly automation to alert someone in 30, 60 and 90 days of a date
I have a sheet that tracks employees certifications. I'd like to setup a single automation that runs weekly to alert the employee when the expiration date is within 180, 90, 60 and 30 days away. I'd prefer that the 180 day alert only be sent monthly until the 90 day date is hit, then weekly. I'd like the message sent to…
-
Need someone's logical brain on a formula
Hi all, I need help fixing this formula: =COUNTIFS({TGN Bluesheet Tracking List Range 4}, =DATE(2023, 6, 20), {TGN Content Range 2}, =AND("Facebook" "Instagram" "Threads" "X" "YouTube")). I'm trying to pull the number of a specific dropdown list from a specific date. Any ideas on the best formula?
-
Sort Report by the Summary result
I am having a report grouped by region and summarized by numbers of process per region. it's only sorted alphabetical by region not possible to be sorted by summary numbers. Easy feature appreciate if it could be existed soon. Thanks team, Shorouk Helmy
-
Comment Conversations Inconsistent Contact Dropdowns
Hello! I've experienced this issue for some time, but it's becoming more of an issue with the number of comments we need to add to a particular sheet. When adding Comments/Conversations, I am able to @ tag a user using their email, but also sometimes their name. While I can always use their email, I can often not search by…
-
Looking for ideas to improve my current daily process re: managing references
Hi all, This is a very open question to see if I can get ideas from the community to improve my daily morning process with Smartsheet. Apologies for the lengthy question- this is outside of my usual very specific help request. I'm responsible for our Company's data; in the property insurance- independent adjusting world.…
-
Updating Project Stage Advancement formula
We have a current formula for Project Stage Advancement, that updates the Project Stage field when all tasks under in the section have been marked 100% and a task in the next section has been marked In Progress. =IFERROR(INDEX([Task Name]:[Task Name], MATCH(MAX(COLLECT([Start Date]:[Start Date], Status:Status, OR(@cell =…