-
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…
-
Local Government Uses
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, Human Resources (Performance Reviews?), Permit Tracking, and Finance. Brett
-
Access Security for Forms
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 Smartsheet login I use Smartsheet forms to submit project tasks (not too confidential) and…
-
Adding resources cost
Hi all, I'm fairly new to smartsheet, and i wanted to know how do i use the "bill rate", ca I change it? How can I access it? I think this is the solution for my issue which is i want to add the costs to my resources and I couldn't find the best practices for that. Would love to hear any tips and recommendation. Thanks,…
-
Incremental Budget Forecasting based on Monthly Due Date Percentages
In excel, we have two sheets: Sheet 1 - A percentage breakdown per country based on historical data for each Month prior or after the Due Date month. Zero = Month Due Date. -1 = the Month prior to the Due Date Month, etc. Sheet 2 - For Country, Due Date and Projected Total Spend, we calculate (via formulas) the Current…
-
changing email address in contact list (web formular)
Hi everybody, I use a contact list in a web formular. Unfortunately, it is not possible to write a new email address into the drop down list which is not yet included in the list. It simply disappears after writing it + Enter. Is there a way to do so? greetings Joerg
