-
Setting Rules and Conditional Formatting
I am trying to make a rule that when I am finished with a cell and change a status on that cell it will then transfer it to another sheet. In short when I am finished with a project and have colleceted payment and finished with the set project; that I can make a rule to where it will then have a pre set rule to where I can…
-
Locking a Summary Row
Hello, Is it possible to have a summary row at the top of my sheet that is "locked" sort of. Meaning, when i filter on certain criteria, the summary row will only total that criteria.??
-
Preserve leading 0's:
-
Make Stars yellow by Default
I am creating a New Hire Checklist and one of the columns is called required. If that row's task is required the start will be checked and show up yellow. How do I make all the starrs in the required colum yellow by default? So we have to uncheck only what isn't required instead of vice versa.
-
Autofilling Columns on different sheets
Is there any way to auto fill columns on different sheets. We run hundreds of events a year and it would be great if when we add an event the name of the event and other details are automatically added to our various staff members sheets without us having to send them all a memo of a new event to add.
-
Tip for Day to get the team to play.
One of the things that we have done as of late to speed the ability to work in the sheet and for people to move about in the sheet is hyperlink your sub sheets to your master sheet. The Hyperlink creates a fast way to go to anothe sheet without closing the main sheet. If you have you settings correct you can have a new tab…
-
Can we add charts and metrics to create a dashboard
Is there a way to add charts or create real time dashboards.
-
Is it possible to restrict Check Box Columns to specific user or account types?
I am trying to create check boxes on a shared sheet that only I can check as approved, is this possible?
