Finance

Discussion List

  • Dashboard Sharing: Is there a way to check all the Dashboards I currently have published?
    In Using Smartsheet
    Hello, I've created a few Dashboards and published them for viewing. After viewed, I removed the publish option in order to stop anyone from acessing them. Is there a way to check all the Dashboards I currently have published? I wanted to …
    Accepted
    51 2
    Accepted Answer 51 views 2 comments Most recent by Jose Vale Using Smartsheet
  • 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
  • Attachment in an online Form
    In Using Smartsheet
    Hello, I have creeated an online form but I need that people can add an attachment (image). Anyone knows if this is possible and how?  I guess it is possible as this form I am filling in has  this feature. Thanks you for your help Ugo …
    4571 12
    4.6K views 12 comments Most recent by Andrée Starå Using Smartsheet
  • 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
    33 1
    Answered - Pending Review 33 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
    52 1
    Answered - Pending Review 52 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…
    1117 22
    1.1K views 22 comments Most recent by Paul Newcome Formulas and Functions
  • FORMULA NOT WORKING
    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 …
    232 12
    232 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…
    882 11
    882 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…
    Accepted
    53 7
    Accepted Answer 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…
    475 7
    475 views 7 comments Most recent by Andrée Starå Formulas and Functions