-
SUMIF formula with range
=SUMIF([Total Sales of Goods and Services]@row :[Total Sales of Goods and Services]@row, [Payments in Quarter]@row = "Q.3.18")) The purpose of this formula is to sum all totals of Total Sales of Good and Services if the Payments were made in Quarter 3, 2018; I'd like to make this formula workable per selected quarter for…
-
Date range formula
I am trying to write a date range formula with an IF AND statement (I think). I need to check a box if [Previous date] is in a specific date range.
-
Project Cost Calculator Smartsheet
I am looking for a template in smartsheet that I can use to build costs for projects and training courses we conduct. I noticed that on the smartsheet website advertisement it says that smartsheet has the solution. My goal is to program some of our costs to do business with certain rates and then send forms to the Program…
-
Commission tracking
Good morning Smart Sheet community. I have been tasked to create a commission tracking smart sheet for our sales team. If you have a pre-fab sheet(s), and willing to share, I would be forever grateful. Otherwise, here was my thoughts on said sheet. First sheet would be for the actual sales. This would have a form available…
-
IF Formula Based on Selected Quarter
Hi, I would like to write a formula that selects the appropriate sales tax rate with each quarter. I think I may be missing something basic when if comes to IF formulas...Does it matter if the sales tax column was created as a dropdown list? Is there a limit to the length of this formula if I were to add on with future tax…
-
RYG Status based on Variance
Greetings, Does anyone know if there is a formula to automate RYG based on Variance? I am trying to track budget (not dates). I would like to show Red balls when a task is over budget. Any ideas on the formula? Thank you!
-
Looking for a Guru to Build a Smartsheet + Quickbooks Solution
Hi I have a small engineering company 15 people that has not been able to find a real good Portfolio management solution so am considering creating my own with Quickbooks + Smartsheet. I use Smartsheet for managing commissioning projects so would expand this to include all of the 125 projects we currently have on the…
-
How can I display a date range based on week/month numbers?
Here's the situation: I have a bar chart on a dashboard that displays the dollar value of bids submitted by week going back the last five weeks and another for the last five months to help the estimating team track where we are on meeting goals. At the moment the labels under the bars are Last Week, 2 Weeks Ago, etc.…
-
Keeping old and new data when needing approval/decline
We use Smartsheet for forecasting budgets per team. Each team has its own sheet with each line item that rolls up to sheets, reports, and a dashboard (with graphs and metrics). The columns represent both forecast and actual money spent per month (two separate columns per month). When a product owner adds a forecast amount…
