Sheets

 

Discussion List

  • Relating sheets many to many
    In Using Smartsheet
    Hi there. I am trying to design a set of sheets in Smartsheet to allow two different types of projects to be related to one another. I have species projects in one sheet and site projects in another sheet. I want to relate these two she…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Paul Newcome Using Smartsheet
  • Hourly view on Gantt View
    In Using Smartsheet
    Hi there, We have a project with vehicles moving across multiple locations and would like to keep tract of their activity by the hour. We don't so much need to track their GPS location as much as, Car # 1 is in Town A, and then needs to g…
    Answered - Pending Review
    13 1
    Answered - Pending Review 13 views 1 comment Most recent by Sean Morgan Using Smartsheet
  • Changing data on a survey that has already been submitted?
    In Using Smartsheet
    Hello - I have a question about a mistake I made on my survey. I have one sheet that holds 6 survey forms. I have a unique identifier that is hidden from the respondent but will let me know which survey the response is for when it fills in…
    Answered - Pending Review
    23 1
    Answered - Pending Review 23 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • "When Triggered" Automations Behaviour
    In Using Smartsheet
    A colleague of mine has sent me a question that has stumped me and has got me thinking my understanding of how automations work has been wrong. She sent me the following: We have automations that are set up to send when triggered that sen…
    Answered - Pending Review
    40 4
    Answered - Pending Review 40 views 4 comments Most recent by Paul Newcome Using Smartsheet
  • Hi There, I have a column with comma separated strings. How to find the occurrence of each string?
    In Formulas and Functions
    Please see the below table. I have 20,000 responses. I need to find out how many times each response was given. I have 20000 responses. I need to find out how many times each response was given. Thank You.
    Answered - Pending Review
    23 6
    Answered - Pending Review 23 views 6 comments Most recent by Paul Newcome Formulas and Functions
  • Can you use Groups in Contact list column type?
    In Using Smartsheet
    We have different groups created under user management, for example, email team, marketing team etc. I wanted to know if they can be used inside a column with contact list column type for a project? If yes, how? If not, what exactly is the…
    Accepted
    163 7
    Accepted Answer 163 views 7 comments Most recent by Andrée Starå Using Smartsheet
  • Current year streak and rolling unbroken streak formula help
    In Formulas and Functions
    I have a dashboard metric that I could use help with. I have a Consistency Club to recognize associates that achieve their monthly sales activity metrics, measured by individual month. Meaning if they have achieved their metrics for Jan,…
    Answered - Pending Review
    39 1
    Answered - Pending Review 39 views 1 comment Most recent by Genevieve P. Formulas and Functions
  • Recommended format
    In Using Smartsheet
    Hi there, I'm looking to track daily activities of field staff. This involves broadly tracking daily tasks but perhaps more importantly location of staff in the field (who is where and when) and the work vehicle they are using (we have ab…
    Answered - Pending Review
    15 5
    Answered - Pending Review 15 views 5 comments Most recent by Andrée Starå Using Smartsheet
  • Color code Gantt bar
    In Using Smartsheet
    Hi there! I'm looking to code the color of Gantt bars based on the value of a different colum, called "Location". Is there a way to do this? Thank you, Esperanza
    Answered - Pending Review
    10 3
    Answered - Pending Review 10 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • 2 or more projects sheet dependency
    In Using Smartsheet
    HI, I am using Smartsheet and I am involve in 3 projects and all are main and lead roles.  I made 3 separate sheets for each project but I realize each projects affect the other projects and then sometimes the predecessor is in another sh…
    1771 9
    1.8K views 9 comments Most recent by CWats716 Using Smartsheet