-
Sharing Resource Views with Other Resource Viewers
We are getting started using SmartSheets Resource Management tool and I would like to create a few different resource views for some of our supervisors. Essentially each supervisor will have a view of their team so they can see what projects their team is working on and when. My issue is that I've created a few of these…
-
Formulas Dissappear
Is there a way to keep the formulas from dissappearing? I have a formula set to check if the checkbox is checked but if the checkbox is checked independently from the main checkbox then the formula seems to dissappear. Also, is there a way to view the form as another type of user, ie...viewer, or editor? Thanks YouTube of…
-
Enhancement Request: Choosing which task to display on Agenda
Hi, A great way to improve your existing features regarding Sync with Google Agenda (or even the regular Agenda view) would be to allow the user to check or uncheck the tasks he wants to be synced, and the ones he doesn't. I use a lot of titles or categories for my tasks and subtasks but most of the time they are…
-
Calendar view that displays the allocated resource
I have several project spread sheets with resources allocation. I built a report that brings the spread sheets together to display the tasks assigned to the various days. I would like this same calendar data to dislpay a calendar view of the resources allocated to the various days. The questions is how? The calendar view…
-
Update Request single use link
Does anyone know if there is a way to allow a recipient of a "Send update request" to use the same link more htan once to update a particular row? An installation within my organization is a single day event but can span the entire day. I may need multiple check-ins from my field tech. Today, I send an update request to my…
-
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.…
