Discussion List

  • Auto-Populate Left Stub for Schedules
    In Formulas and Functions
    Thanks to Paul Newcome, I was able to get a WBS schedule working. Now I need to create several schedules, using the WBS as the left two columns. Here is the problem - I need for all schedules to update whenever a row is added or deleted …
    Answered - Pending Review
    22 5
    Answered - Pending Review 22 views 5 comments Most recent by Andrée Starå Formulas and Functions
  • Expense Report Ideas
    In Using Smartsheet
    I am trying to build an expense report sheet for external attendees that come to trainings. Is there a way to allow them to submit each expenses separately through a form but then somehow automatically group rows together so that we are o…
    Answered - Pending Review
    43 1
    Answered - Pending Review 43 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • SUMIFS and Referencing Another Sheet (Financials) = INCORRECT ARGUMENT SET
    In Formulas and Functions
    Hello all, I'm trying to compile some financial totals for various departments into a Metrics sheet for Dashboard reporting and something is not going right. I can get the total for all departments from the referenced sheet with =SUMIF({To…
    Answered - Pending Review
    67 1
    Answered - Pending Review 67 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • The 25,000 cell reference limit is puzzling
    In Formulas and Functions
    Dear Smartsheet: I am a bit confused by the 25,000 cell reference limit.  In my specific case I am simply trying to VLOOKUP from a table where I have 700 rows and 17 columns.  That equals 11,900 cells which is less than 25,000 cells.  So…
    1221 22
    1.2K views 22 comments Most recent by Paul Newcome Formulas and Functions
    In Formulas and Functions
    HI,   I have a formula  =IF(E3>0,E3-C3,TODAY()-C3) this works great in excel but in smartsheet it comes back with #INVALID COLUMN VALUE  can anyone help fix this issue?? Please see attached excel with formula in Column D  Thank you …
    258 12
    258 views 12 comments Most recent by Andrée Starå Formulas and Functions
  • =SUMIF Month-to-Month
    In Formulas and Functions
    I am trying to create a graph for a Dashboard that will display the total amount of approved $$ within each month and total amount of denied $$ within each month. I will also need a rolling YTD total. So far this is what I have for the for…
    1055 11
    1.1K views 11 comments Most recent by Paul Newcome Formulas and Functions
  • Calculating a minimum payment figure using a formula or function
    In Formulas and Functions
    Hello, I'm hoping someone may be able to help me with something that probably seems quite obvious or basic however, my knowledge on formulas or functions within Smartsheet is not advanced, so I apologise in advance! I'm trying to get my fi…
    53 7
    Answered ✓ 53 views 7 comments Most recent by Paul Newcome Formulas and Functions
  • Plotting cost over time
    In Formulas and Functions
    Hi- I am trying to either graphically or with subtotals display cost over time as aggregated preferably by month, but also want to consider by week.   I am easily able to plot cost for items that begin or end in a calendar month, but not…
    581 7
    581 views 7 comments Most recent by Andrée Starå Formulas and Functions
  • Local Government Uses
    In Using Smartsheet
    I am a Mayor of the city in Washington. We are looking at Smartsheet to add as a project management tool for staff. I am interested in how other local governments are using Smartsheet? Specific areas of interest are Capital Projects, H…
    94 0
    94 views 0 comments Started by Brett Gailey Using Smartsheet
  • Access Security for Forms
    In Using Smartsheet
    Does anyone know if there's a way to limit form access to a specific person or group of people.  Or, is there something in the works at Smartsheet to address this?  Looks like there is currently two options. * Anyone * Anyone with a Smart…
    670 6
    670 views 6 comments Most recent by Lushenkm Using Smartsheet