Company Management

Discussion List

  • Graphing Data
    In Formulas and Functions
    Hello All, I am trying to build a graph of data and I was hoping someone had some ideas for me. Scenario:  Multiple locations use a form to input data on incidents that occur at their location. The form has them input incident type (from …
    69 0
    69 views 0 comments Started by cthrasher97141 Formulas and Functions
  • Unhide all columns
    In Using Smartsheet
    I need to be able to unhide one single column. NOT ALL. Is there a feature where I can pick the column I need to view. We have weekly columns that go back 2 plus years. I do not need to see over 100 columns unhidden. The unhide all feature…
    68 1
    68 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Templates for Architecture Projects
    In Using Smartsheet
    Are there any templates available for architectural design project? I know there are several construction templates but I am more interested in architecture / design specific and the workflows related to the specific processes.
    NP Profile Photo NP
    314 2
    314 views 2 comments Most recent by Andrée Starå Using Smartsheet
  • Automation to Move Rows from Sheet to Sheet is not working
    In Using Smartsheet
    I have my sheets set up where each row represents a project and respective information.  I have a column in each that can be changed to a department heading and I have an automation set up to make it so that when changed the rows move to t…
    227 3
    227 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Track Daily Variance Between Forecast to Actuals Across Multiple Cells and Sheets into Master View
    In Formulas and Functions
    Hello, I am desperate for some guidance on the best way to handle my situation. First, I have 2 sheets that I'm attempting to provide an executive view for: * First sheet is a forecast that indicates the number of people we should be tr…
    223 1
    223 views 1 comment Most recent by Alejandra Formulas and Functions
  • Formula to flag red with multiple criteria
    In Formulas and Functions
    Hi. My name is Frank. I have been working on this formula for quite a while now including requests to Smartsheet support. The formula is to raise a red flag when the end date is less than 3 days away with specific status options. I finally…
    139 6
    139 views 6 comments Most recent by FEspo Formulas and Functions
  • Report and Calendar View
    In Using Smartsheet
    I created a report from a sheet.  The report contains only a few columns.  This report is intended to be mostly used for calendar view.  The items we want viewable in the calendar are the same items contained in the report -- not the main …
    183 2
    183 views 2 comments Most recent by alwayslearning Using Smartsheet
  • Status Report based on certain conditions, i.e. dates, status etc
    In Formulas and Functions
    Hi Smartsheet community,  I'm trying to come up with a status report to display information on what has been done in our projects between certain dates. I would really appreciate your expertise and help!!! For example: Project A Status …
    230 5
    230 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Inconsistent Date Options
    In Using Smartsheet
    Hi  I recently came across 2 date-related options which look inconsistent within the app.  Would be grateful if the smartsheet development team can address it soonest! The Inconsistency:  In the Workflow-Automation we can set a Condi…
    25 1
    25 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • SumIf with Date Range
    In Formulas and Functions
    I created a project management financial sheet (client / projects / deliverables & invoicing). I am trying to sum the value of invoices between a date range (screen grab).  This is what I thought would work: =SUMIF(DTI:DTI, AND(@cell…
    112 3
    112 views 3 comments Most recent by L_123 Formulas and Functions