-
Conditional Formatting Help
Is there a way to highlight a row when a box is not checked by a certain time. We are trying to use as sort of a time clock, and our boss wants a way to easily track who is not on time. For example, making the row highlight to red if the box is not checked by 8am. Does anyone know a way to do this?
-
Can you reduce the depth of a row so only the 1st or 2nd rows of cell content are on view
-
Once a field is marked to yes ignore the rest of the formula
I am trying to create a sheet where as a step is completed the steps are updated with a checkmark symbol. As a drop down comment is added in a column the formula updates the step to complete. However onece I change the drop down comment the symbol changes back to "No" or X. I would like to know if there is a why to write…
-
Master Task List By Resource
We have multiple projects ongoing simultaneously. In each project tasks are assigned to various team members by the managing partner. Is there a way to have a task automatically roll into a master task list for the manager by resource (sort of a pivot table) or a consolidated task list for each resource team member to…
-
Commission sheet
I'm looking for a Sales Commission sheet that tracks sales, commissions earned, etc. We have a junior salesman and a senior salesman who produces and earns overrides on the junior. Much appreciated if you could share one or perhaps a screenshot to get me started.... Thanks - Scott
-
Best practices for incorporating human resources/work force for company with multiple divisions
I'm trying to find the best way to incorporate my companies career path/employee roles for mulitple projects throughout five divisions. Request the best practices for resource management for mulitple projects.
-
Employee Management
I am looking to start a smartsheet to track employees and when they work. What I am looking for is a management sheet that can list all my employees, their titles, pictures, tasks and most importantly for this sheet their work schedule. I own a Martial Arts School so I have 26 employees over two schools working full time,…
-
Including only the most recent comment.
Hi there, Within the "Print Setup" for .pdf reports, under "Options", "Include comments" checkbox....when selecting this checkbox it prints out the full set of comments which is fantastic but can make the report quite lengthy, especially over time. However is there a way, or is it possible in future upgrades to select an…
-
Promoting Smartsheet
How much does anyone else promote this program. Have you heard the words"are these guys paying you". I just completed a mastermind group and it was a dominate topic for me in addressing how business owners can advance their company. I am wondering what is the level that all of us on here feel and promote about this…
-
Combining a check box & date in one cell? Is this possible?
Does Smartsheet have the capabilities to include a date and a check box in one cell? or Several Checkboxes in one cell? Or Text and a Checkbox in one cell?