Solution Center
Discussion List
-
Remove Primary Column From ReportIn Using SmartsheetI 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!
-
Embedded IF(AND(OR Function HelpIn Formulas and FunctionsHello, 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…
-
Need help in AverageIf formula with 2 conditionIn Formulas and FunctionsHi 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…
-
Smartsheet Reports are not getting saved and information is not showingIn Using SmartsheetWe 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…
-
Filtering Columns in ReportsIn Formulas and FunctionsI 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 views 5 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Smartsheet dashboard viewIn Formulas and FunctionsHi Team, Can anyone suggest me how to create this kind of view in smartsheet.Answered - Pending Review 12 views 1 comment 0 points Most recent by Bassam Khalil Formulas and Functions
-
Sales Pipeline - Period ViewIn Formulas and FunctionsHi, 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 views 1 comment 0 points Most recent by Bassam Khalil Formulas and Functions
-
COUNTIFS between dates & criteria.In Formulas and FunctionsGreetings 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: …
-
Dropdown Multi select - ~If formulaIn Formulas and FunctionsHi 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…
-
Auto populate data and allow customers to updateIn Formulas and FunctionsHi! 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…
