Finance
Discussion List
-
Dashboard Sharing: Is there a way to check all the Dashboards I currently have published?In Using SmartsheetHello, 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 …
-
Auto-Populate Left Stub for SchedulesIn Formulas and FunctionsThanks 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 views 5 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Attachment in an online FormIn Using SmartsheetHello, 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 …
-
Expense Report IdeasIn Using SmartsheetI 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…
-
SUMIFS and Referencing Another Sheet (Financials) = INCORRECT ARGUMENT SETIn Formulas and FunctionsHello 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 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
The 25,000 cell reference limit is puzzlingIn Formulas and FunctionsDear 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…
-
FORMULA NOT WORKINGIn Formulas and FunctionsHI, 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 …
-
=SUMIF Month-to-MonthIn Formulas and FunctionsI 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…
-
Calculating a minimum payment figure using a formula or functionIn Formulas and FunctionsHello, 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…
-
Plotting cost over timeIn Formulas and FunctionsHi- 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…
