-
October Question of the Month 💭 Join the conversation and receive a badge
Hi everyone, We're ready to kick off October with a new question and opportunity for you to earn some badges and points while getting to know your peers! What is one thing that scared you until you did it? Could be joining a new company, taking on a new project, sky diving or something else. Drop your answer in the…
-
[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…
-
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…
-
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.…
-
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…
-
I need my sheet to highlight rows based on the number of days open, any help?
Need help with creating a formula that will calculate days open, if the row is not checked complete. Can anyone help?
-
Dividing to Create a %
I would like to use the data in Column A and B to create a percentage complete by row NOT by parent/hierarchy. In Excel this would be =sum(Column B/Column A) = %. What is the formula for Smartsheet?
-
How to change a legal name associated with an email?
I've got a user who changed her name legal first name last year and Smartsheets will not allow me to edit the name in the contacts. Even though I've removed it from my auto-fill and contacts list this old attribution is stuck. I assume it's because she's cached somewhere in our old Smartsheet lists. Is there a way to force…
-
What is the Required checkbox on the Customize Profile Data page of Control Center for?
I'm curious what the Required checkbox on the Customize Profile Data blueprint setup page of Control Center for? Does it control anything specific? Never been entirely sure so I figured I'd ask to see if anyone can explain it. Thank you!
-
Automation is running but rows are not being copied onto corresponding sheet...
Hello, I have created an automation that will send a notification email and copy rows into another sheet when a box is checked to indicate that a cost center needs to be charged. In several tests of the automation, the emails were received but nothing has been copied over. I have double checked that the correct sheet is…
-
How to rank dates
Hi, I could not find any posts regarding this. Basically, I am making a sheet for managing projects where, for each task, there is multiple gates (step 1, step2, etc.) which have multiple dates (actual advancement date, baseline [first estimate], forecast [estimate based on actual advancement] and planned [ updated…
-
Filtering columns by Color
Using either conditional formatting or manually selecting a background color for a cell, it would be great if we could then sort or filter a column by a specific color. There could be numerous use cases for this including "highlighting changes made to a specific column that we want to filter on instead of using the…
-
Smartsheet Form Hyperlinks opening in a new tab
Ability for hyperlinks to open in a new tab in Smartsheet forms so entered information is not cleared. If the hyperlink is not in the form description section (embedded in a field help text) it will clear out all of the information in the form.
-
VLookup Question
Hello, I am looking to compare two sheets each month. I have VLookup searching for 4 individual pieces of information from the Monthly Sheet within the Master List: Employee, Merchant, Date, Amount. Currently, I have =VLOOKUP(Employee@row, {Master List Name}, 1, false) that looks for the Employee Name and will either…
-
Automated Update Request depending on how old the data is
Hi there I'm baffled - this sounds like a standard process but I can't work out how to do it and would appreciate any advice. I have a database, the first item in column one is "UPDATE DATE". I want to use this to trigger an update request - ie: if the date is older than 3 months, send an update request, and keep doing so…