Hi to everyone I would like share with others users my questions about peparing the sheet for organize the jobs of the company where I work to see what are you guys think about this subject. I have to organize and follow every job of the company. The company have a lot of jobs (many hundreds) and in each jobs have about 15…
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…
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.??
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.
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.
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…
Is there a way to add charts or create real time dashboards.
I am trying to create check boxes on a shared sheet that only I can check as approved, is this possible?