Discussion List

  • Pre-populate a form
    In Using Smartsheet
    I am building a change control log. Is it possible to pre-populate a form with cell data from a sheet? For example, project name, ID, customer, description and resource from the sheet to help the process of logging a change to the change c…
    Answered - Pending Review
    6080 62
    Answered - Pending Review 6.1K views 62 comments Most recent by Steve Gebbie Using Smartsheet
  • Is there a formula or function that allows text to be removed and replaced elsewhere on the Sheet?
    In Formulas and Functions
    Hard to explain just in the question box. We have a staffing schedule for our company which allows us to see who is currently on jobs and who is coming up for availability for an upcoming job. We are trying to figure out if there is a type…
    Answered - Pending Review
    11 3
    Answered - Pending Review 11 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Return Column Names AND values from row in a reference column
    In Using Smartsheet
    I'm trying to figure out how to return the columns and values found in them for any given row. I have approximately 200 unique columns that are populated from a web form if/when the column is relevant. individual rows track construction i…
    Answered - Pending Review
    43 11
    Answered - Pending Review 43 views 11 comments Most recent by Genevieve P. Using Smartsheet
  • Sorting & Filtering Linked Cells From Source Sheet
    In Using Smartsheet
    I am unable to figure out how to sort and filter linked cells from the source sheet. I have a sheet with cell links which needs to be sorted or filtered when the source sheet is sorted or filtered. I am unable to use a report or dashboard…
    264 6
    264 views 6 comments Most recent by Cory Strischek Using Smartsheet
  • INDEX/MATCH function doesn't return exact match.
    In Formulas and Functions
    I'm having and issue with the MATCH function not returning an exact match. If my understanding of the formula is correct: "1" for the [search_type] should find the first value greater than or equal to the search_value starting f…
    Answered - Pending Review
    24 1
    Answered - Pending Review 24 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Automatic Children Indenting
    In Using Smartsheet
    Hello,   Is it possible to set up a formula for information (if it is the exact same as the parent/child row above) that you have underneath a child/parent row to automatically attach itself inside the Parent/Child Hierarchy? I would rat…
    1396 21
    1.4K views 21 comments Most recent by Paul Newcome Using Smartsheet
  • Zero Formula
    In Formulas and Functions
    Where do I find the formula to have a cell display nothing when the total becomes the number zero? I have a sheet with zeros in multiple places and it clutters to much. 
    Answered - Pending Review
    1495 34
    Answered - Pending Review 1.5K views 34 comments Most recent by BenG0706 Formulas and Functions
  • Time Tracking - Hours and Minutes
    In Formulas and Functions
    I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-ar…
    1353 5
    1.4K views 5 comments Most recent by L_123 Formulas and Functions
  • RTF in Dashboard Widget
    In Using Smartsheet
    I downloaded an example dashboard which tracked multiple projects.  Looked good and decided to build my dashboard to match example.  Example dashboard has a Rich Text Widget which has multiple formats within.  However when I try to use the…
    508 12
    508 views 12 comments Most recent by Roland Horwood Using Smartsheet
  • Kanban View - printing or saving to PDF
    In Using Smartsheet
    In the Kanban sheet, can this be saved to PDF in card view or printed in card view ? currently it shifts to list view when printing.
    441 8
    441 views 8 comments Most recent by Alberto Ferrari Using Smartsheet