Consumer Products
Discussion List
-
How to use end date and percentage complete to automate RYG statusIn Archived 2016 PostsHi everyone, Maybe my brain is struggling with IF and AND statements, but this is defeating me. I am trying to use the end date of a task compared to today's date and the percentage complete (great than or equal to 75%) to drive …
-
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…