-
Unhide Columns (Selective)
Not sure if this was a previous discussion item, but wondering if there is a selective way to unhide certain columns, or is just the all option. Problem being I have large amount hidden and at times just want to revert back and unhide one or two. Thanks in advance, Tom
-
Number of users active in a sheet at one time
I'm new to the community. I'm sure this question has been asked many times before, but I cannot find a suitable answer: Is there a limit to the number of users that can be active / accessing a sheet at the same time?
-
Back ups
Hi, Is it possible for one person to be able to back up and schedule future back ups for the whole of our organisation? I have figured individuals can do this but i would like to put the responsibility into one department and under one person? I would be grateful of any information regarding this. Regards Dave
-
Automated Status Ball color change
I have the following formula shown below that changes the Status symbol (Gray/Green/Yellow/Red) based on the Phase/Risk/Change Implementation Date. I tried to update it for a new Phase "Canceled" but I keep getting the error #UNPARSEABLE. Is this due to the fact that I'm trying to have both the Phase "Operationalize" &…
-
Average of lease $ amounts in a certain region
I would like to see the average lease amount per region. I am cross sheet referencing. The formula for the average works. But when I add in the second part (countifs) to make sure a PE GL Checkbox has been checked and to specify a region (I do a cell reference) it doesn't seem to work. For instance, in 1 region I do not…
-
Count if column 1 matches column 2
I'd like to create a formula in a summary cell at the top of my sheet that counts rows in which the value in 1 column matches the value in another column at the same row. I'm hoping to do this without creating a helper column. Example: Col1 Col2 1 1 =1 2 2 =1 3 0 =0 4 3 =0 5 5 =1 I'm guessing there is an obvious answer,…
-
Sorting Issues
I'm still looking into this but has anyone had any issues with the sorting feature? We have one sheet that 17 people are constantly working in a day. (All Editors and 2 Admins if that makes any difference) This morning we SORTED several rows and HOURS later someone who had the sheet open, saved their data and INSTANTLY ALL…
-
Numerous issues in last few days
Have others been experiencing any unusual activity in the past few days? I have been having a number of issues that appear to be related to permissions and reports e.g. A report we use daily suddenly showed a permission error for one of the users in the team although their permissions have not changed and they are owner of…
-
RYG Automation using Drop Down lists
Hi I've watched a few videos on RYG automation based on due dates but is anyone able to help with the IF function using categories from a drop down list instead? I.e. Looking at Recruitment Status: If someone chooses 'On Hold' from the drop down, I want the RYG column to show Red. If someone chooses 'Interviews and…
