Finance
Discussion List
-
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
-
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 67 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…
-
Local Government UsesIn Using SmartsheetI 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…
-
Access Security for FormsIn Using SmartsheetDoes 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…