-
Automatically Update Master Sheet Linked to Other lesser sheets
Hi Guys Now this might sound basic but I havent figured it out just yet lol. Basically I want to have the master sheet and when the users of the other linked sheets add a row of data to their sheet, it updates and adds it to the Master sheet also. Is this possible with the linked cells function?
-
tracking Project by the hour
I have started a small project shedule for a job that will take around 72 hours to complete total but with multiple subs having to start and finish at certain times to hit that deadline. how do i change the calendar on the Gant to #1) just show me the 3 day assigned to the task #2) break each day down to a 24 hour time…
-
New Personal Profiles, Improvements to Card View, and More
Our new release focuses on more visibility with your collaborators using Personal Profiles, more visibility in Card View with displaying subtasks, and the ability to preserve Notifications when making a copy of your sheets. Let’s take a look at these new features: Personal Profiles—Add more information to your account to…
-
Count down in days formula
I need help finding the right formula. I have basic Gantt with four phases, each phase has tasks associated with it as well as durations. I've set a "start date" column and by using durations for each task and predecessors I then have the calculated "finish date" column for each tasks and each phase. I need to create a…
-
Populated Report for me but blank for Recipient
I'm wondering if anyone else has had this issue before.... I created a report from one sheet that has approximately 14 lines on it; the person I shared the report with shows it to be blank. The Report Builder, on their end, shows the 'Where?" as <unknown sheet>; the "Who?, What? and When?" are the same as what was built.…
-
Column Visibility Restriction or Accessibility
My sheet got 10 columns and is shared to 8 people. 8 of the columns are name of the person I shared the sheet with. Is it possible that person 1 can only view and edit the column assigned to his name? If it is can you teach me how? Thanks!
-
2fa or similar options
Is there anyway to secure our accounts with 2fa or the like?
-
Weekly columns
Hi there I think I am missing something here. I want to set up a list of tasks which will be due in certain weeks of the year and are repeated. For example. * Review website pages... Second week of each month * Write a blog article: Last week of the month * Post Facebook update: Each week. Do I set up 52 columns with the…
-
rounding up
Hi All. We are trying to make an order form that calculates a number typed by our clients to a box rate. To do this we have tried dividing the order by the amount per box then rounding up to a full box. we have been advised to try this.add a flat value of 0.5 to anything returned by the above formula. This will force any…
