Consumer Products
Discussion List
-
Blank Rows in Gantt - Automatically get populated by start dateIn Using SmartsheetIn 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…
-
Integrating non working holidays on another countryIn Using SmartsheetHi 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…
-
If, Then FormulaIn Formulas and FunctionsHi 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…
-
[Need Help] Non-License user can hide column but can't unhide?In Archived 2017 PostsHi, 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…
-
Number and Fraction FormatIn Archived 2017 PostsWe 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…
-
Gantt view on a dashboard reportIn Using SmartsheetI'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…
-
SUMIFS using Fiscal Year Date RangeIn Formulas and FunctionsI'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 …
-
Formula to automatically check a box when a certain cell is populatedIn Formulas and FunctionsI 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…
-
OR function to check a boxIn Formulas and FunctionsI 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…
-
Reaching for Specific Information ReturnIn Using SmartsheetI 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…
