Consumer Products

Discussion List

  • Blank Rows in Gantt - Automatically get populated by start date
    In Using Smartsheet
    In Gantt format - I leave some rows blank to separate workstreams or buckets of work. But for whatever reason - Smartsheet goes and fills just the start date automatically in these row. I delete them, and then after I save, they come bac…
    11 1
    11 views 1 comment Most recent by Alejandra Using Smartsheet
  • Integrating non working holidays on another country
    In Using Smartsheet
    Hi fellow Smartsheeters, I encountered this problem after entering American holidays but our operations is affected by other suppliers in other countries like China.  I think many of you have been affected by week long holidays like Chine…
    72 3
    72 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • If, Then Formula
    In Formulas and Functions
    Hi everyone, I've searched through the community but couldn't find the right solution. I need to feed specific sales metrics into a dashboard but want it to update, according to the Today column. I receive the previous months information…
    51 4
    51 views 4 comments Most recent by lisarae723 Formulas and Functions
  • [Need Help] Non-License user can hide column but can't unhide?
    In Archived 2017 Posts
    Hi, I understand that only License user can hide or un-hide column in sheet they are admin. * Hide/unhide columns (also requires Sheet Owner or Admin access to the sheet) But we have some user (non-licensed but part of our Business) tha…
    JMD Profile Photo JMD
    171 4
    Closed 171 views 4 comments Most recent by J. Craig Williams Archived 2017 Posts
  • Number and Fraction Format
    In Archived 2017 Posts
    We currently use a considerable number of sheets that need numbers to read as fractions.  (Construction/Exhibit Industry for dimensions) Unfortunately, if you type out a number as a fraction it cannot be used in formula.  Excel can transla…
    382 7
    Closed 382 views 7 comments Most recent by Brienbe Archived 2017 Posts
  • Gantt view on a dashboard report
    In Using Smartsheet
    I'm trying to include a report with it's corresponding Gantt chart on a dashboard. The report is set to open on today's date. However, in the dashboard the Gantt chart starts in June and I can't even scroll back to today's date (see attach…
    724 7
    724 views 7 comments Most recent by Andrée Starå Using Smartsheet
  • SUMIFS using Fiscal Year Date Range
    In Formulas and Functions
    I'm trying to sum monetary amounts for a certain customer while referencing the data from a separate sheet. However, I only want to sum those amounts that fall within the FY20 (fiscal year) dates of 4/1/19 to 3/31/19. Here's the start of …
    121 1
    121 views 1 comment Most recent by Brian W Formulas and Functions
  • Formula to automatically check a box when a certain cell is populated
    In Formulas and Functions
    I am trying to get a column to automatically check a box when certain cells are populated in the same row. This is linked to an update request situation. Basically, when an update request is fulfilled, OR when a certain cell has informatio…
    1245 2
    1.2K views 2 comments Most recent by Andrée Starå Formulas and Functions
  • OR function to check a box
    In Formulas and Functions
    I am trying to get one box to check under one or another conditions. 1. when a certain cell has any text 2. When another certain box is checked The function I came up with follows, but it doesn't seem to work. There might be one small t…
    529 1
    529 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Reaching for Specific Information Return
    In Using Smartsheet
    I am trying to use a set of sheets for material tracking from various suppliers without actually having to have my employees use several sheets to do it.  I am wondering if there is a way/formula to look through a specific column for a sup…
    21 6
    21 views 6 comments Most recent by Paul Newcome Using Smartsheet