Smartsheet Basics

Archives for June 2019

Duplicates - Check mark all occurrences except the last/newest one
Hello, When duplicates exist, is there a way to check mark all occurrences except the last occurrence? I used the following formula, but it check marks all occurrences except the first occurrence. =IF(ISBLANK([Badge ID Number]1), "", IF(COUNTIF([Badge ID Number]$1:[Badge ID Number]1, [Badge ID Number]1) > 1, 1)) My sheet…
Limit rows on a report
Sorry if this has been asked somewhere else.I am new to SmartSheet and have had a look in community but couldn't find an answer. I have a Kanban board setup in SmartSheet and have a few reports running that are displayed within a dashboard Currently I have a report that pulls all items and orders by a creation_date field…
Cross-sheet references
Can anyone please help with this? I'm getting the error code #CALCULATING, which I think must be because I must've gone over the 25,000 limit. I've archived about half the rows though and I'm still getting the same error.
Create HYPERLINK in form ?
hi, i created 2 form in smarsheet, and i want user to be able to choice between the 2 form but with only 1 hyperlink ? can i do it with smartsheet or maybe another pogram ?
How to set a task finished signal one by one
Hello, If I finish one task then I can go to next task, otherwise it can't go to the next, How can I achieve this.
Using COUNTIFs with FIND & AND
Hi, I need to add up the following: 1) All Labeled as Country X from a Qualitative field that is requiring me to use the FIND function. 2) All labeled as AreaY across 3 columns (I have tried selecting all columns as a range and also just selecting the relevant rows as well). Currently using: =COUNTIFS({Consultant…
Ideas on transition between annual project tracker sheets
Hello, I am looking for a way to "connect" two Smartsheets that track a variety of projects (one for 2019, one for 2020). Curious to see if anyone has done this, recognizing that some work may extend into the next year, and if there are any lessons learned / pro-tips in creating and maintaining such a concept. Thanks for…
Why am I receiving automation email replies?
I set up an automation that will send a PO request to external clients. When they reply to the automated email it comes to my email address and not the person that was requesting the PO. 1. Does it come back to me because I created the automation rule or because I own the sheet? 2. If I sent an update request instead of an…
Automation Trigger "When Rows are Changed" not working
I have been banging my head on this. I need to set up a very simple trigger that when a cell is updated, a notification is sent about that row. I am using the "When Rows are Changed" trigger and defining my cell condition, and filters. I have also tried the "When Rows are added or changed" trigger with no success. I have…
Sorting install dates in ascending order without the parent function interferring
I divided all of the PM's into parent functions and then have their jobs listed as children functions currently. One of the applications they want is to be able to filter by installer then sort the install dates by ascending order to see if there are any overlaps. However; when I enter the filter and then sort the dates it…

Upcoming Events

Brandfolder Collaborator User Guide
Get ready to seamlessly upload and organize content within your Brandfolder! This on-demand session is designed to help you become a confident contributor and collaborator, ensuring your team has the right assets at the right time. What You’ll Learn: Maximize Features in the Asset Modal: Learn to navigate the asset modal,…
Brandfolder Admin User Training
Managing digital assets doesn’t have to be complicated. Join us for this two-part, on-demand webinar series designed to give Brandfolder administrators the confidence and skills to create smooth, efficient workflows. Whether you’re just getting started or ready to optimize your setup, these sessions will help you unlock…
Smartsheet Customer Success Onboarding (Japan)
Smartsheet カスタマーサクセスオンボーディングは、Smartsheet についての基本を学びたい方向けに毎週開催しているインストラクター主導のトレーニングコースです。ウェビナーは、始めるための基本、共同作業、およびさまざまな方法での作業の視覚化の基本など、Smartsheet のご利用を開始するために必要なすべてを網羅しています。
Smartsheet In Person User Group | Raleigh
Connect with fellow Smartsheet mobilizers and advocates! Join us at our in person user group in Raleigh, NC on Jan. 15. This is a great opportunity to discover how other local users are optimizing their use of Smartsheet. *Get inspired: We'll learn from local users, who will share success stories on how they use Smartsheet…

Trending in Smartsheet Basics

Limiting Access to Folder and it's assets
I shared access to a user to a specific folder under workspace A (folder is 2025-09-Service Factory). However, I can see that he's shown to have access to all the other child folders under 02-ACTIVE Initiatives. Why is that when I only shared out one folder? Is there a way to only share access to users to ONLY specific…
How can I view the Gantt chart in days?
When I use the zoom-in option, I can only see the day names but not the specific day numbers. I need my team to be able to see the exact dates for the tasks I have scheduled.
Not enough space in the cell for my notes
Hi, I'm using smartsheet to track updates on each task in a tracker. These updates may span over a year, so they get lengthy. I was excited about smartsheets because viewing these notes is a lot cleaner. However, I've just realized that there is a content limit to a cell, which is a huge issue. While excel was annoying to…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video<

Smartsheet Basics

Discussion List