-
Sharing a report but not the source spreadsheet
I want to share part of a spreadsheet with a subcontractor. However, I do not want them to have access to the full sheet. For instance, source data: A B C D E F G H Data to share with subcontractor. They also need to be able to edit/update columns A, B, C. A B C According to the help page, this is not possible, but maybe…
-
start time for a task
Is it possible to enter a start time for a task. e.g. I enter a task for 4.5 days, but I want it to start at 12.00 on the first day and then use the following four full days. Thanks Dale.
-
Conditional Forwarding from Web Forms
Hi folks - our business has been using Smartsheet for around 2 years now, but we really haven't taken advantage of some of the more powerful aspects of the software. I'm learning about forms and their uses, and I've come across a challenge I'm hoping you can help with. I've created a form from a sheet (lets call it…
-
Favorite Smartsheet formatting tricks!
One of my favorite formatting tricks is the disapearing checkbox. This trick allows your header rows to look clean (without blank checkboxes). Check it out: https://www.smartsheet.com/blog/support-tip-formatting-tricks What's your favorite formatting trick?
-
What does "collaboration" mean to your organization? Looking for examples.
Collaboration is a term that is being used a lot lately and I'd like to have some examples of what it means to different organizations. One of our Smartsheet customers said it captures "togetherness, team unity and relationships". Another large company in Seattle defines it as, "knowing where to get information when you…
-
How to set up a departmental time off request sheet?
I was wondering how I could set up a document that is one sheet for time off. The main things we need are a form or something to fill out that will go to the employees specific manager to approve or deny, and will then notify the employee if it has been denied or approved, and if approved, will then populate in the sheet…
-
Project Management: Weekly capture of actuals against planned hours
Many thanks in advance! We have a team of project associates that are asisgned to a number of tasks on a project in a smartsheet. I want to be able to send a timesheet to each resource at the end of every week. On the timesheet I would like to display the task for the week and ask for actual hours to be entered. These…
-
Is there a way to apply conditional formatting or grouping to reports?
Looking for a way to utilize the reports functionality. It would really help to have conditional formatting capability as well as grouping functions.
-
User Management and Contact List type
Good morning, If I am understanding this correctly, the User Management is what the Contact List type draws from to populate names. Is there a way to create different groups within the User Management area? For instance, I'd like to have two separate lists so that I can have two different Contact List types in my sheet.…
-
If / and formula
I am having a slow day, brain wise today. I need to have a formula for a RYG column, that looks at two check box columns. First checkbox will change the RYG ball from Red when not checked to Yellow when checked. Then i have a second check box column for another department to change the SAME RYG ball column to GREEN when…