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

  • Index and Match Vs Vlook up
    In Formulas and Functions
    Hi all, I was advised to use Index and Match as I am pulling dates from various schedules into one sheet. Last time Vlookup worked really well however there was a limit of 25000 links. Now I am using index and match and the limit is even …
    Answered - Pending Review
    2 2
    Answered - Pending Review 2 views 2 comments Most recent by Avinash Chandra Formulas and Functions
  • Duplicates
    In Using Smartsheet
    I have a student sheet that I am copying over for the next semester. I copied only the data but didn't want the comments, attachments, filters, links, etc. However, there are duplicate names on sheet and I want to know if there is an eas…
    Accepted
    13 5
    Accepted Answer 13 views 5 comments Most recent by jgneely72151 Using Smartsheet
  • Resource management
    In Formulas and Functions
    I was trying to use the resource management function of Smartsheets, but that really is not giving me what I want and it is pulling from sheets the Assigned To is on, but I do not want to include in my resources. So I thought I might be a…
    Answered - Pending Review
    12 2
    Answered - Pending Review 12 views 2 comments Most recent by Kimberly Washeleski Formulas and Functions
  • IF AND statement
    In Using Smartsheet
    I am attempting to build out a system which checks a box based on a hidden checkbox and a drop down field. If the hidden checkbox is checked, and the dropdown field shows either "In Progress" or "Not Started" the visibl…
    Accepted
    12 3
    Accepted Answer 12 views 3 comments Most recent by David Tutwiler Using Smartsheet
  • Using If Formula to Populate Status of Parent Row
    In Formulas and Functions
    I am looking for help writing a formula to populate a parent row of a Single Select Dropdown column. The Parent row should reflect the Status of the Child rows - for instance, if any of the Child row statuses are set to Not Started, In Pro…
    Answered - Pending Review
    17 3
    Answered - Pending Review 17 views 3 comments Most recent by Bridgett Alonso Formulas and Functions
  • Using COUNTIFS with CONTAINS
    In Formulas and Functions
    When I try to incorporate a CONTAINS into a COUNTSIFS i keep getting errors Works fine: =COUNTIFS({JSA - Daily Job Start Safety Form Range 1}, [email protected], {JSA - Daily Job Start Safety Form Range 2}, $Date$1) Incorporate CONTAINS : These ar…
    Answered - Pending Review
    12 2
    Answered - Pending Review 12 views 2 comments Most recent by Nicole Paulsen Formulas and Functions
  • INDEX() function help
    In Formulas and Functions
    Hi, I have a master list of tasks in one sheet with project specific labeled columns. I'd like to break out those columns into separate sheets. My thought is the best way to keep the master list current while transposing data, using a com…
    Answered - Pending Review
    2 1
    Answered - Pending Review 2 views 1 comment Most recent by David Tutwiler Formulas and Functions
  • Help Creating a formula using Children
    In Formulas and Functions
    Hi! I currently am experimenting with Parent and Children Hierarchy to clean up my sheets. Below is a screenshot so you can see my mock up page. The issue I am running into is when I add an additional "Project", my formulas in t…
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by David Tutwiler Formulas and Functions
  • Today / Yesterday formulas
    In Formulas and Functions
    Hi all, I need to create a dashboard to include all calls made to clients, either today or yesterday (the idea being that the charts would change on a daily basis). My issue is that I don't think I can use the Today or Today -1 type formu…
    Answered - Pending Review
    12 5
    Answered - Pending Review 12 views 5 comments Most recent by David Tutwiler Formulas and Functions
  • Contact List is NOT restricted in Report
    In Using Smartsheet
    I'm wondering if someone knows what's going on here! In our main sheet, the contact column (Crew) is restricted to 2 contacts, but in the report that drop down is showing many other contacts. I have the contact column in the main sheet set…
    Unanswered
    7 0
    Question 7 views 0 comments Started by AmandaM Using Smartsheet