-
working with forecasting and actual sales amounts
This is the formula I am trying to activate to pull some sales data from a master sheet to a monthly summary by sales person. =SUMIFS({Current Lead Opportunity Tracker 2019 Range 3}, {Current Lead Opportunity Tracker 2019 Range 1}, "xxxx@xxxl.xx.xx", {Current Lead Opportunity Tracker 2019 Range 8}, "2", {D&C Current Lead…
-
Posting/Including data from another cell.
Within my sheet I have two columns that contain time (hh:mm:ss). In the third cell I am comparing the two columns. If they do not match a statement is posted in a cell stating something is wrong. What I would like to add to the statement is the value from one of the cells containing the time. This works, with no added…
-
Pushing cell data to a map for plotting
Hi all, Im building a capability for an operations centre with smartsheet and was wondering of I can push cell data, such as an address to a GIS system to plot the tasks onto a map like Scribblemaps or the like?
-
Using MONTH formula with a blank date cell
I have been using the month formula to create a month number from an 'Actual close date' column. however i get error when the source column 'Actual close date' is blank I can get the month number to work when dates are included with =MONTH([Actual Close date]4) and I can clear away error message if source is blank with…
-
Rollup Formula
I have a rollup sheet. I am needing a cross sheet formula to calculate total quote for a specific sales rep. See screen shots below. Thanks so much your help. I really do appreciate it!
-
Monthly Turnover Time
Hello, I am working to create a widget on a dashboard. In order to do this, I want to get data between a start date and end date (turnover time) per month to show monthly progress. I have tried by finding the month and year but I'm not sure how to attach the turnover time days with its corresponding month/year . . .…
-
Unable to Copy and Paste
Hey all, I am currently unable to copy and paste text from Microsoft Outlook into Smartsheet. I can copy and paste text from within Smartsheet forms, but cannot paste text from any other sources outside Smartsheet. I was able to use this function until it suddenly stopped working yesterday. I utilize this function every…
-
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.
-
SUMIFS Issue
Hi, I have a client master list on my Smartsheet and I want to get the total monthly fee of those clients that have an "Active" status Both the monthly fee and status are in my Smartsheet and when I tried using =SUMIFS(MONTHLYFEE:MONTHLYFEE,STATUS:STATUS,”Active”) I got an #UNPARSEABLE error. Please help. Thanks!
-
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…