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

  • Combine Cells with Unique Identifier
    In Formulas and Functions
    I have a sheet that allows users to scan certain components online They may scan the same tracking number, but different components online at several different times in the process. Is there a way to combine all of the same tracking numbe…
    Answered - Pending Review
    14 1
    Answered - Pending Review 14 views 1 comment Most recent by Genevieve P. Formulas and Functions
  • Can somebody help trying to read only data from this Month
    In Formulas and Functions
    Hi My plan is to bring data from the current month, from a different sheet using cross sheets formulas. My code below is not working any idea why? It says #UNPARSEABLE Any help is much appreciated =SUMIF({Actual Completion Date}@row)=MONTH…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Genevieve P. Formulas and Functions
  • Multisheet dependencies
    In Formulas and Functions
    Hello! I am working on multiple projects for a single client, but need them to communicate with each other so no two tasks are assigned to the client at the same time. I understand there is a manual way to create dependencies between sheet…
    Answered - Pending Review
    22 1
    Answered - Pending Review 22 views 1 comment Most recent by Genevieve P. Formulas and Functions
  • Auto Label Parent Rows
    In Formulas and Functions
    Hello! I'm looking for ways to automate labeling the parent rows for an onboarding sheet. I want to automate the label of the day so that I won't have to manually adjust it every time. Here's a sample a screenshot:
    Accepted
    52 5
    Accepted Answer 52 views 5 comments Most recent by Annielyd Sepulveda Formulas and Functions
  • collaborators
    In Using Smartsheet
    Hi, i've just update my license from individual to pro. i didn't have any problem in individual license, buat now all collaborator became view only. I've try set as Editor - can share, editor - cannot share and Admin, seems nothing works.…
    26 1
    26 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • Dollar Sign Not Showing in Metric Sheet
    In Formulas and Functions
    Hi Everyone! I'm not great with formulas, and I was hoping someone might be able to help me figure out what I'm missing. I have a column in a sheet that contains dollar amounts. I then have a separate metrics sheet where that column to…
    Answered - Pending Review
    14 3
    Answered - Pending Review 14 views 3 comments Most recent by Genevieve P. Formulas and Functions
  • Conditional formatting of hyperlinks
    In Using Smartsheet
    I searched the forums but couldn't find a solution to this. I want to apply conditional formatting to my hyperlinks, but it's not working as intended. The italicizing works, but the font color stays blue and the underlining remains. It…
    Answered - Pending Review
    14 1
    Answered - Pending Review 14 views 1 comment Most recent by jodyh Using Smartsheet
  • Distinct Formula
    In Formulas and Functions
    Hello!! Thank you in advance for any assistance you can provide me. I have 2 columns (Assignee, Total Tickets) - Assignee is comprised of a list of names (most are formatted as email but a few are stated names). I need to create a formula…
    Answered - Pending Review
    11 2
    Answered - Pending Review 11 views 2 comments Most recent by Nichole Formulas and Functions
  • Contact value based on formula
    In Using Smartsheet
    I'm using Smartsheet (named Projects) to track progress on some projects. One of the columns in the sheet contains a Territory #. There is a Sales Manager assigned to each Territory which is kept in a separate smartsheet with one column (t…
    Accepted
    23 4
    Accepted Answer 23 views 4 comments Most recent by John Knipper Using Smartsheet
  • Publishing and Google Search indexing and crawling
    In Using Smartsheet
    Business and Enterprise users can publish a sheet, report, or dashboard. My question is can these pages be discovered by Google Search indexing and crawling? These are the options I refer to: I looked at the page source on a sheet I publi…
    Accepted
    183 9
    Accepted Answer 183 views 9 comments Most recent by Llucson Using Smartsheet