-
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…
-
How to create totals for different columns for a specific date range
Hi I am struggling to get the total for all the columns in my sheet for each week Monday- Sunday. My entries are created via webform. I need to take into consideration the created date for my weekly time range Could somebody help me please? Thank you :)
-
Formula to display duration of a project
Is there a formula or a work around to produce the duration of a project when given the start date of the project and the end date of a project? In Excel (=DATEDIF(D9, E9, "d") is a simple formula but in Smartsheet what am I'm missing?