functionality

Discussion List

  • Usability Problems on Big Sheet
    In Using Smartsheet
    HELLO I HAVE AN USABILITY PROBLEM CURRENTLY OUR MAIN SHEET (ADMIN_2021) IS ONLY USING 41% OF CAPACITY, ACCORDING TO THE REPORTS OF EACH SHEET. INFACT WE HAVE 204.000 ACTIVE CELLS TO DATE (CURRENTLY USING 51 COLUMNS AND 4000 ROWS ) I AM THE…
    Answered - Pending Review
    11 8
    Answered - Pending Review 11 views 8 comments Most recent by Gerardo_Clarke Using Smartsheet
  • Weekly Comparison
    In Formulas and Functions
    Hello guys, I am trying to add a column that will provide me a %complete for previous week. I have this week's percentage and a PM is updating that weekly however I was wondering if there is a way to have another column that would be upda…
    Answered - Pending Review
    100 12
    Answered - Pending Review 100 views 12 comments Most recent by R Smith 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
  • 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
  • VLOOKUP/JOIN/COLLECT - Need help combining groups of emails
    In Formulas and Functions
    Good afternoon, I am stumped & hoping someone can help. In short, I have a Reference Sheet with the contact info and a Communication Plan Sheet. In the Reference Sheet, I added an Address/Filter/Email List column. The Email List is gro…
    Accepted
    26 3
    Accepted Answer 26 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Require Help with COUNTIF Formula on Smartsheets
    In Formulas and Functions
    Hello everyone! I am trying to count the number of records for the current year(2021) from 'System Generated' date column -(Request Date )with formula - =COUNTIF(Request date: Request date, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())) in the '…
    Accepted
    23 5
    Accepted Answer 23 views 5 comments Most recent by medhapar Formulas and Functions
  • Formula to color RYG balls based on date/deadline
    In Formulas and Functions
    Hello, I'm trying to alter the color of our RYG status balls based on the proximity of the date. For example: Yellow - if today's date is within 5 days prior and 5 days after the deadline date noted Red - if today's date is 5 days + afte…
    Accepted
    272 11
    Accepted Answer 272 views 11 comments Most recent by Abe B. Formulas and Functions
  • Auto Sort
    In Using Smartsheet
    Hello, Is there any way to create automation that will automatically sort a sheet when a cell is updated or changed? Thank you, Sean
    Accepted
    238 4
    Accepted Answer 238 views 4 comments Most recent by latheobald89201 Using Smartsheet
  • Locating the parent of a parent
    In Formulas and Functions
    I am trying to take the value from the primary column of a level 0 parent and insert it into another column in a level 2 child. =PARENT([Task Name]@row) works fine when there is only level 0 and level 1. Something like parent of a parent i…
    Accepted
    534 5
    Accepted Answer 534 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Row ID (ignoring blank cells)
    In Formulas and Functions
    I am trying to create a sheet which identifies batches of 25 rows and creates a specific batch ID, before moving onto the next 25 rows. (Batch Column) I also need to formula to ignore rows with blanks entries. (Row ID) I hope somebody is…
    Answered - Pending Review
    11 2
    Answered - Pending Review 11 views 2 comments Most recent by Jen R Formulas and Functions