-
Smartsheet API Docs Site is Getting a Major Upgrade!
Hello, Smartsheet Developer Community! We're excited to share about significant improvements coming to our Smartsheet API documentation site! Get ready for a smoother, more interactive experience. What's Changing? We're moving our Smartseet API documentation to a brand-new, revamped site! Here's what you can look forward…
-
Preparing for a Password-Free Future in Smartsheet: Share Your Feedback!
As part of our ongoing commitment to security and authentication best practices, we are preparing to deprecate password-based login for Smartsheet accounts. Our goal is to transition to more secure authentication methods, such as email-based Time-Based One-Time Passwords (TOTP) and eventually full two-factor authentication…
-
March Question of the Month - Join the conversation and receive a badge
Happy March, Community! Thank you for sharing your fantastic badge ideas on last month’s question, and for celebrating the Community’s 10th anniversary with us (don’t miss the giveaway!). Some of those ideas might inspire future badges, so keep an eye out for them. 👀 As always, you have a new opportunity to earn badges…
-
Share Your Pivot App Experience & Earn a Gift Card!
Hi Smartsheet Community, The Pivot App team is inviting users to participate in research interviews to help us improve the Pivot App. We're interested in understanding how you use it and how it fits into your daily work. Your feedback is invaluable, and we'll thank you with a gift card for your time. Ready to contribute?…
-
Happy 10th Anniversary Community + Giveaway!
Hey there, Community! We have a very exciting milestone to celebrate with all of you — The Smartsheet Community is hitting its 10 year anniversary this month. Can you believe it? Read all about it on the Press Release here. We are so thankful for every single one of you, whether you joined us in 2015 or today. 🥳…
-
Feedback requested: Shape how Smartsheet communicates with other tools!
👋 Hi there! I'm part of the product team interested in how you handle your Smartsheet work across different communication channels like Teams, Slack, email, video calling, and other tools. 🛠️ If you could wave a magic wand to fix any challenge with communicating across different tools about work you’re doing in Smartsheet,…
-
Hide empty lanes and add child items in timeline view, now generally available!
March 17, 2025 We're excited to share two new long-requested timeline view enhancements: Hide empty lanes when grouping: We introduced a new “Show empty lanes” toggle in the "Group by" toolbar button in timeline view. This toggle allows users to determine whether "empty" lanes (i.e. lanes with no records in them in a given…
-
Community Corner Newsletter [March 2025]
Hey Community friends, A big shoutout to @Marcela for sharing her amazing adventure with the Social Responsibility Pillar in last month’s edition! If you missed it, you can find it here. Since both Marcela and I are from Costa Rica, it’s no surprise that we share a deep love for nature and outdoor adventures. Last summer,…
-
Celebrating the women of Smartsheet Community
Hello Community! March is Women's History Month, and we want to shine a light on the amazing women here with us in the Community and all around us. Your contributions help make this a wonderful place for everyone, and we're grateful to have you here. Recognizing women in the Community Every month, we give the spotlight to…
-
Smartsheet Forward 2025 Edition 1: Innovations to help you collaborate, automate and get work done
As we kicked off 2025, with the Jumpstart 2025 with Community event, many of you reflected on your goals for the new year. With workflows growing more complex—more tasks, dependencies, and content to coordinate — the latest issue of Smartsheet Forward couldn’t be more timely. In this issue you’ll hear about how we’re…
-
Can you use the TIME function to calculate the difference i.e. duration between values in 2 columns?
Hello, I've previously used the many pointers and guidance on the forums for coming up with solutions that help calculate time and duration between columns using a range of different helper columns.. I've never used the TIME function before, but I'm hoping I can use this to try and save having to add multiple helper…
-
Countifs for if either column is checked
I have two checkbox columns and need to get a count of how many rows have either or both of the check boxes checked. I am struggling on how the formula to accomplish this is the sheet summary. Below is my current equation for getting the count of one of the columns, I am able to do this for both to get a count for each…
-
Formular Stripped from cell when the row moved into different sheet
Hello, I use simple formular to assign Due date =WORKDAY (Start Date, #of days) to add. I love it- Simply Works! Attached image. Now, when this row met workflow automation criteria, and then move into different sheet as completed, the formular no longer display. Only show Due date value. It this stripping formula normal? I…
-
My IF statement isn't importing from excel and can't figure out why
I have what I think is a fairly simple nested if statement that isn't importing into Smartsheet, it just shows blank and I can't figure out the issue. The excel formula is: =IF(ISNUMBER(C2), IF(AND(ISBLANK(X2), ISBLANK(Y2)), TODAY() - C2 + 1, IF(AND(ISNUMBER(X2), ISBLANK(Y2)), X2 - C2 + 1, IF(AND(ISNUMBER(X2),…
-
New User..
Hello, I am a new user to Smartsheet and have a question on Saved Automation Workflows. I am trying to edit the email by adding a due date in the subject line of the email once it reaches a trigger date. Please advise on how I can change the due date from month.
-
Form not auto populating fields if one column cell contains a comma
I'm using a form that when triggered, populates several fields from a source sheet then posts to a another sheet. I've noticed that if the column titled "Description" has a comma in the text of a cell, such as image 1 below, then the form will not auto populate all of the fields that I want. It will also stop populating…
-
Countifs off by one
I am trying to get a count for a date range, but am getting a number that is one less compared to the filter. Current Tuesday Formula: =IFERROR(TODAY() + (3 - WEEKDAY(TODAY())) - IF(OR(WEEKDAY(TODAY()) = 1, WEEKDAY(TODAY()) = 2), 7, 0), "") Previous Tuesday Formula: =IFERROR(TODAY() - 7 + (3 - WEEKDAY(TODAY() - 7)) -…
-
Issues with Convert to Column Formula
Hi, I have a column that I'm trying to convert to column formula but won't because "The column formula syntax isn't quite right" and gives me Smartsheet's help article for more information. The column's type that I'm trying convert is "Symbols" and is the Progress Bar. The Formula of the attached example is: =IF([RPM %]851…
-
Charting a multi-select column using a metrics helper sheet.
I have a sheet with a multi-select column (Law Firms) and I wish to show a chart in my dashboard that displays a count of the unique firms in that column. I created a separate metrics sheet with one column (Law Firm Names) containing each unique value contained in the multi-select column. In my other column, I'm using a…
-
Copying Workflows between Sheets
In my operational work I use Sheets as Action Trackers for all the countries we are implementing my project. When I was tracking about 5 countries I got the idea to create workflow that if any task is assigned to me the line is automatically copied to another sheet that is actually my Kanban Board so in one place I can see…