-
Advanced Reports in Resource Management by Smartsheet now generally available!
Hi Community, We are excited to introduce "Advanced Reports," a new feature in Resource Management by Smartsheet. This release brings significant value to organizations utilizing Smartsheet and Resource Management. With "Advanced Reports," organizations can now automate their Resource Management reports—covering Time &…
-
Be aware of one-time Smartsheet login screen update
Hello Community, As part of our latest security enhancement related to the email TOTP login method launch, you may notice a one-time change in your login experience. Users accustomed to seeing their last login method (as shown in sample Image 1) will see a new login screen (as shown in sample Image 2) only once. What you…
-
FAA Streamlines Aviation Safety Communications by Centralizing Project Tracking in Smartsheet Gov
The Federal Aviation Administration (FAA) Office of Communications uses Smartsheet Gov to track and manage video animation, graphics projects, social media content, live events, corporate communications, media relations activities, and web development, which increase project visibility, unifies communications, gives…
-
For a limited time - AI access for the AI curious. Start benefiting now!
Hello, You heard right! Now through December 31, 2024 we’re opening up access to Smartsheet AI to all customers. Experience how Smartsheet AI is helping teams save time and unlock insights with our AI tools. Generate formulas: Gain insights into your data by having a conversation and say ”goodbye” to syntax and code.…
-
September Question of the Month - Join the conversation and receive a badge
Community, you always do such a fantastic job with these questions! Last month, we loved learning how some of you explain Smartsheet to the children in your life, and reading the many ingenious descriptions everyone came up with. Comparing it to Legos, Minecraft, magic notebooks, the classroom, and a friendly wizard were…
-
[GIVEAWAY] Enter to win a FREE pass to ENGAGE Seattle 2024
Hello Smartsheet Community, It’s the time we’ve all been waiting for, ENGAGE Seattle 2024 is coming October 8-10. We would love to see you there, so here’s your chance to win a FREE ENGAGE Seattle Conference Pass! Here’s how to win: Submit a unique Smartsheet Community Slogan that captures what makes the Smartsheet…
-
Putting the Pieces Together: Building Systems to Manage Work
Hi Community, Great news! Our latest updates make workspaces simple to build, highly adaptable, work-focused solutions that promote increased productivity and better results all in one location from the big picture down to the details. With our improved workspace, you can create, manage and share everything you need to run…
-
NEW: Share Data Shuttle Workflows!
Hi Community, As some good news for your Friday, we’re extremely excited to announce that you can now share workflows in Data Shuttle! With this release, workflow builders and Smartsheet System Administrators can now add users within their plan as workflow managers to Data Shuttle workflows. Meaning no more worries about…
-
Vendor and External Collaborator Management with Dynamic View in Smartsheet Gov
Join this webinar to learn how to use Dynamic View in your solutions to allow your Vendors and External Collaborators access to the information they need but not see the information they shouldn't. You will learn how to begin integrating the collection of external information into your organization's workflows in a…
-
Higher Education focused virtual user group tomorrow! Link to Register
Higher Education focused virtual user group scheduled for July 30, from 10 - 11 am PDT You can view the registration page here. Please join us for this virtual user group to explore how Morgan State University leverages Smartsheet to optimize work, accelerate timelines, and maximize impact within the Office of the…
-
=SUMIFS formula with 3 criteria
Hello, currently I have a working SUMIFS formula adding revenue from column A based on the status in column B, so my formula is: =SUMIFS({Revenue Column}, {Status Column}, "Completed") But now I have a master data list that separates projects into internal and external, I need to add to my current formula to only count…
-
I want to update a column with a value of '1' based on the count of values in a column
I want to update a column with a value of '1' if the count of values in another column are greater than 1, it doesn't matter what those values are
-
Syncing my ss calendar with Google Calendar, showing events as all-day meetings
I hope to find an answer here: I have an SS calendar with specific start and end times, but when I sync it to Google Calendar, the events show up as all-day events. Any solutions? I believe the start and end times are set correctly in my SS calendar (see attached), Any ideas on how to fix this? Thanks Sara
-
Calendar View Integration with Outlook Calendar by filtration
Is there a way if I were in calendar view and have a filter setup (filtered by 1 specific name and task) I can have it integrated into Outlook based on that one filter instead of it all row submissions dumped into my outlook calendar at all?
-
Links to Smartsheet rows fail due to the last filter used
When our users select a link to a Smartsheet row, they often get the following message, which applies the last filter they had selected and thus hides the record that they're trying to access. Is there any work in progress to fix this? This is in addition to them not being able to sort when a filter is applied is really…
-
Dollar amounts in a form
I am trying to require a form field to only populate a number to display in a dollar format. I can only see the requirement of a number, but not an actual dollar amount. Is this possible in a form?
-
How Do I add Sum(Children) at the bottom of the children rows
Hi, How do I use the =Sum(Children) function in Smartsheet to sum child rows and display the total at the bottom. I usually create a parent row, then add rows beneath it, indent them and add the formula =Sum(Children) to the parent row to calculate the total. However, that structure was confusing for users, and they…
-
Formula (if this is and date beyond, check flag)
Help with this formula (generated through AI). I need it to look at this cell (if it is blank) and another cell (date) is greater than 3 months, turn the FLAG on in ____ (cell). I am missing this other cell name, I believe. Cell/Field is called Protocol FLAG. =IF(ISBLANK([DRAFT Protocol Received (Date)]@row) AND…
-
Hello I am trying to create a formula that returns a specific date when a dropdown selection is made
class requested start date Jan 13, 2025 - July 14, 2025 Oconomowoc, WI Jan 13, 2025 - July 11, 2025 Huntsville, AL (new site) Feb 10, 2025 - Aug 11, 2025 Amsterdam, NY Mar 24, 2025 - Sept 22, 2025 Fontana, CA Apr 21, 2025 - Oct 20, 2025 Oconomowoc, WI May 13, 2025 - Nov 17, 2025 Huntsville, AL Jun 16, 2025 - Dec 15, 2025…
-
How to count values in drop down
I have a training tracker that Managers complete the form to then update the tracker. However I want to be notified when 10+ students have registered for the same course. I will add some screen shots but i.e. if more than 10 ppl register for "Auto" then I would like a count of how many. I added a column per Module but then…