-
How to count quantity of date entries within a month time frame?
Hello All - I have 10 years of data that I would like to produce historical infomration, and eventually trailing charts. I want to produce a chart that will tell me how many leads we received on a per month, per year basis. I have shared a screen shot, and example of what I am trying to do. I keep getting a "zero" for a…
-
Advanced formulas: Countif
I am trying to count the number of visible cells in a cloumn. I do have a filter applies to another column and the coumn I need a count on is a date field. Any guidnce would be appreciated. Or is there a way to count the number of rows between two dates. Example 11/1 - 11/30. Thanks, D
-
Error when trying to print a calendar view
I'm getting an "maximum date range exceeded, please select a custom date range of less than 1000 weeks" when trying to print a calendar view, and I'm only selecting two weeks out?
-
Need to build formula that includes a drop down menu as an option, need advice
I am trying to build a formula that includes a drop down menu as an option. This is what I am trying to do ... =IF([COLUMN1] = "Campus name", then [BUILDING NAME], otherwise "Please select your campus before selecting the building name") * COLUMN1 would be a drop down menu with campus names * BUILDING NAME would be a drop…
-
Tracking Hours in a Day
Hello Fellow Smartsheet Users, I am looking to track hours in a day to maximize bandwidth per employee (OCR Racing & Building Obstacles). Unfortunately, Smartsheet doesn't have the ability to track hours in a day and to accurately display this in a Gantt Chart so I am looking for recommendations/tips, best practices, etc.…
-
What is the best way to associate prospect contact information and sales tasks to a smartsheet sale
We currently use smartsheet for our sales pipeline. I love it. As our prospects move through our sales cycle, we simply move them down the list. I use the formulas to track all of our conversion rates and apply to project types and marketuing sources. I find this reporting and linking feature invaluable. We use the…
-
SETTING REMINDER DATES
Hello to all, I'm completely at a lost with formulas in Smartsheet because they are based on column name and location rather than cells like typical spreadsheets. The examples I find in the help are never similar to what I need, can someone help me please? We have a column for Date of Request and Due Date. Reminders are…
-
Duration setting end date based on 8 hour day, not 10
I changed the length of the work day to ten hours in the project settings. When I set the duration for a task to 1d, the end date changes to the next day. If I change the duration to .08d, the end date is the same day as the start date. Is this a limitation of the trial verison? thanks
-
budget projection based on schedule
hello, I am trying to find a way to create quarterly budget porjections based on estamates in a column and my gantt chart schedule. This will show the project sponsor how much funding he will need to secure based on how much work is being done in a period of time shown in the schedule. Thank you
-
Reporting from multiple sheets
Is there a way I can run a report from multiple sheets? I can select 2 or more sheets but it's an "OR" and not "AND". So, the report isn't reporting on all selected sheets. Or, am I missing something? Thanks!