Join the Smartsheet Community

Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.

Discussion List

  • Automation
    In Formulas and Functions
    Hello, I am looking for a way to condition a symbol column to updated from a text column. Any tips?
    AGM Profile Photo AGM
    Answered - Pending Review
    8 3
    Answered - Pending Review 8 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • How do I setup a flag for duplicates?
    In Formulas and Functions
    Hello, First time posting here ☺ Trying to setup a flag for when the same data is entered in a row, but it's giving me a hard time ☺ help?
    Accepted
    253 10
    Answered ✓ 253 views 10 comments Most recent by Andrée Starå Formulas and Functions
  • Notification when a specific task changes
    In Using Smartsheet
    Hi. I would like to configure workflows or notifications so that if something changes (say a conversation) in a particular task, then the people who are listed in the notification column will get an email notification. We are going to a…
    Answered - Pending Review
    14 4
    Answered - Pending Review 14 views 4 comments Most recent by Andrée Starå Using Smartsheet
  • Calendar
    In Apps, Integrations, and Add Ons
    Hello, I am using Calendar and I put into ny first column date but its not a wll order. I have July after June after July... Could you help me
    Answered - Pending Review
    13 3
    Answered - Pending Review 13 views 3 comments Most recent by Andrée Starå Apps, Integrations, and Add Ons
  • Bar Chart is not scaling to include all data
    In Using Smartsheet
    I have a bar chart with 4 data points: 71, 3, 0, 2. The vertical axis is scaling 0 - 3.5, so it only fits the smaller numbers and it has no bar for the 71. It prints the number 71 under the horizontal axis labels, under the number 0. H…
    Answered - Pending Review
    8 4
    Answered - Pending Review 8 views 4 comments Most recent by Mike TV Using Smartsheet
  • Personal Report from multiple sheets with non-matching Columns
    In Using Smartsheet
    I have a report created from two source sheets. Both source sheet columns match and the report is good. I can edit all the columns on the report. I have a third source sheet that I'd like to add to the same report. This third source sheet…
    Answered - Pending Review
    9 1
    Answered - Pending Review 9 views 1 comment Most recent by Mike TV Using Smartsheet
  • Multiple Criterion with Cross Sheets
    In Formulas and Functions
    Hello I am stumped. I have tried several different combinations to my formulas trying to get them to function. I get an #UNPARSEABLE error most of the time. I have tried this formula =COUNTIFS({Complete Claim Status}, [email protected], {Vendor N…
    Accepted
    8 4
    Answered ✓ 8 views 4 comments Most recent by Melanie S Formulas and Functions
  • Using RIGHT/LEFT or FIND/REPLACE?
    In Formulas and Functions
    I thought that by using RIGHT and returning the values after ", " that it would fix the issue I'm having but depending on the difference in timestamps, I may get 7 or 8 characters so this formula doesn't work out for me. Would u…
    Answered - Pending Review
    13 4
    Answered - Pending Review 13 views 4 comments Most recent by Jimrny Formulas and Functions
  • Formula Criteria - IS ANY OF based on Multi-Select Dropdown
    In Formulas and Functions
    Hey, So I'm going to guess that the answer is no, but I'm going to hope the answer is yes. We have a board that is used to help track hot or critical inbound items. The goal is to retrieve dates from our, lets call them 'Build Trackers', …
    Answered - Pending Review
    9 1
    Answered - Pending Review 9 views 1 comment Most recent by Mike TV Formulas and Functions
  • Formula to pull in fiscal work week is incorrect
    In Formulas and Functions
    I am continually getting the incorrect work week. In the below screen shot the Onboarded Week should be Week 16. Attached is our lookup sheet from smartsheet. Our fiscal week starts on Saturday, January 29, 2022 and the fiscal week ends on…
    Answered - Pending Review
    20 4
    Answered - Pending Review 20 views 4 comments Most recent by Adriane Price Formulas and Functions