-
Data shuffled after I save
Hello all, I have a sheet shared with 7 people. Almost everytime I save there are multiple rows that are randomly shuffled into different spots on the sheet. I have no formulas or macros... I thought I would throw this out to the community, any ideas?
-
Row limitation?
Is there a limit as to how many rows I can have in each sheet?
-
Creating a Workspace with already shared sheets
Hello everyone, So I would like to know wether I need to share a workspace that I have created with sheets that haave already been shared. I have shared 2 x Inventory lists with the team (we are a small team so that was simple) however now that I have over 20sheets in my list I am creating workspaces to better collate…
-
Duration in parent row not calculating
I have a parent row that is indicating duration of its child rows as 78,324 days when in fact it's actually 53 days--February 1 - April 29. (I made sure the dates were all in 2016). I had one row that was showing several thousand days when it was actually 21 days. I fixed that and saved the sheet but the parent row is not…
-
Sorting heirarchy numbers (1.1, 1.1.1, 1.2) in reports
Hi everyone, I am using reports to merge 20 to 30 sheets and sorting them on multiple and different heirarchy columns (containing numbers such as 1.1, 1.1.1, 1.2). This doesn't really work out of the box because the report sort is apparently just a standard natural sort and doesn't recognize this notation. I wasn't able to…
-
Shared To Me and grouping sheets/workspaces
Right now I have about two dozen sheets shared to me. That number is about to significantly increase... because the people that are sharing the sheets with me work on different projects, is there a way to "view" or "group" my shared sheets other than by clicking on the Location or Owner header to sort? Say, one group for a…
-
Is there a way to select from a project schedule the next upcoming milestone?
Is there a way to select from a project schedule the next upcoming milestone. I have a flag column identifyng milestones and a column that calculates for just milestones the number of days between the task finish date and today's date and therfore the lowest value is the next upcoming milesone. I desire to pull the…
-
Contact List - Assigned to - automatic alert?
Hi guys, Is there a way to automatically 'alert' someone if they are 'assigned to' a task using a contact list column? Would love to hear a workaround if you have found one. Cheers
-
Continuously moving inventory - keeping a record without overwriting current information
Hi there, We have an existing Inventory database in Excel that i have imported successfully. However now I need to figure out - if I can - how to 'track' the movements of any given piece of equipment. For example we have a Computer Monitors that are 'loaned' to customers every so often. I woud like to keep a 'log' of the…
-
Updating Rows - by way of existing Webform
Hi all, So I have a simple sheet, webform attached which is working well with no issues. Rather than updating each individual cell ON THE SHEET, can I bring up the row's information as a webform (or something similar) in a way that shows the information in that row (filled in the appropriate places on the 'pop up'…
