Solution Center

Discussion List

  • Remove Primary Column From Report
    In Using Smartsheet
    I am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it.   Thanks!  
    1215 8
    1.2K views 8 comments Most recent by Rocci Doria Using Smartsheet
  • Embedded IF(AND(OR Function Help
    In Formulas and Functions
    Hello, I have three columns in my sheet each with dropdowns including a "Complete" - type answer and a "Not Required". In the fourth column, I am trying to write a formula to show when the row is 'good to go' - such th…
    Accepted
    12 3
    Accepted Answer 12 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Need help in AverageIf formula with 2 condition
    In Formulas and Functions
    Hi team,  I need help with an AverageIF formula. I am working on the request tracking system for Import shipment.  I would like to calculate the average days in transit with 2 conditions, 1. Country (USA, UK, Sweden, etc), 2. Mode of trans…
    Accepted
    32 3
    Accepted Answer 32 views 3 comments Most recent by Mark Cronk Formulas and Functions
  • Smartsheet Reports are not getting saved and information is not showing
    In Using Smartsheet
    We are continously facing Smartsheet loading and saving issue. The reports are not reflecting and reports are not getting saved after we fill the details. Our entire organization is stuck at this point. PLEASE LOOK INTO THIS IMMEDIATELY. I…
    Answered - Pending Review
    32 2
    Answered - Pending Review 32 views 2 comments Most recent by Naveen Raj Using Smartsheet
  • Filtering Columns in Reports
    In Formulas and Functions
    I have a master sheet which has data pertaining to different departments. From this master sheet, I'd like to show only the information relevant to a department to that department, and none of the other data. 1) How do I restrict the data…
    Answered - Pending Review
    32 5
    Answered - Pending Review 32 views 5 comments Most recent by Andrée Starå Formulas and Functions
  • Smartsheet dashboard view
    In Formulas and Functions
    Hi Team, Can anyone suggest me how to create this kind of view in smartsheet.
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Bassam Khalil Formulas and Functions
  • Sales Pipeline - Period View
    In Formulas and Functions
    Hi, I have a few sheets of Sales Pipeline for each Manager. I have brought all of the estimates sales data together in a separate sheet and created a Dashboard using this. However, I would like to only see data relevant to the particular …
    Answered - Pending Review
    13 1
    Answered - Pending Review 13 views 1 comment Most recent by Bassam Khalil Formulas and Functions
  • COUNTIFS between dates & criteria.
    In Formulas and Functions
    Greetings Smartsheet Community,     I am attempting to cross reference another sheet and Count all the Completed tasks within a certain time frame.    So far I am successful counting the dates in the range using the following formula: …
    2876 20
    2.9K views 20 comments Most recent by Paul Newcome Formulas and Functions
  • Dropdown Multi select - ~If formula
    In Formulas and Functions
    Hi all,   Been searching about this, but could not find anything so far. Hopefully you can help me. I am just starting to make use of the multi select dropdown list. So i have a spreadsheet with some information in the first few column…
    1863 8
    1.9K views 8 comments Most recent by Genevieve P. Formulas and Functions
  • Auto populate data and allow customers to update
    In Formulas and Functions
    Hi! I work for a membership based trade association and I'm trying to build a form that would allow me to share profile information on file with our customers (member companies) and then allow them to update outdated information. For exam…
    Accepted
    23 4
    Accepted Answer 23 views 4 comments Most recent by Andrée Starå Formulas and Functions