-
HOW TO SOLVE INDEX MATCH WITH DATE TENURE?
This is Table 1 This is Table 2 The criteria is Match the Date & Name from Table 1 to find the Amount and put it in Table 2. And also add the amounts which is under the date tenure for the specific month. After many research I have found a formula which can mach 2 criteria at once but its not working for add the amounts…
-
Dashboard Sharing: Is there a way to check all the Dashboards I currently have published?
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 make sure I haven't left any of them out.
-
Auto-Populate Left Stub for Schedules
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 from the original WBS sheet. Simply using Cell Linking does not achieve this. Here is…
-
Expense Report Ideas
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 only paying each person one time for multiple expenses? These people will only attend…
-
SUMIFS and Referencing Another Sheet (Financials) = INCORRECT ARGUMENT SET
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({Total}, but when I add the criteria for each department I get # INCORRECT ARGUMENT SET.…
-
The 25,000 cell reference limit is puzzling
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, why am I getting this error? It creates an incredible amount of frustration and…
-
FORMULA NOT WORKING
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 in advance :)
-
=SUMIF Month-to-Month
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 formula: =SUMIFS({RSA Form Range 2}, {RSA Form Range 9}, "Green", {RSA Form Range 3},…
-
Calculating a minimum payment figure using a formula or function
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 finances in order and thought I'd use Smartsheet to plan this. I've done a screen shot…
-
Plotting cost over time
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 for items that span months. I am pretty sure each cost would need to be broken down into…