-
Sheet automatically scrolling across as soon as I place mouse in sheet.
I have one sheet (that is shared) that automatically scrolls across to the right of the screen as soon as I place my mouse in it. I can not manually correct it back to centre or to the left of teh screen so i can read the data in it. My other sheets are not affected, and are working fine. Can you please recomend a remiedy.
-
Date miss matching
Hi all, Ok so I reside and work for a company based in Bangladesh and we use this format for date ( Date / Month / Year ) so today will be 30/3/2019 I have two base sheet that feeds directly to a master sheet via direct cell linking which is used by the management to keep track of the latest updated. Now the base sheet the…
-
Avoid Overbooking a Training Facility
Hi, When creating a project grid for training events, I add a column named "Venue". In this column I provide the name of training facility where the training needs to be conducted. Hence, I need a way to be alerted when using the same venue more than one time on a specific day. Because, obviously, i cannot run two…
-
Cells are not aligned in the same row.
Hi, For some reason, there seems to be a misalignment between the first two cells in any row with the corresponding rest of the row. As if there is a split between them. The split grows as I scroll down. A very strange thing. The screenshot below shows the issue. I have selected multiple distinct horizontal rows. This is…
-
Report vs workspace permissions
Hi all, can someone please verify whether the workspace-level permissions override the sheet or report-level permissions? For example, I have a user I'd like to have Viewer permission on the overall workspace but Editor permission on a specific report. He has Editor permission on the underlying source sheet (located…
-
Help with SUMIFS & INDEX/MATCH Formulas
I need to first find the column number where the number 1 resides on the "Lookup Value -->" row. Next, I need to shift two columns to the right, which would be "4/2019 C" and sum the values for Client B, I have tried various combinations of SUMIFS, INDEX(MATCH()), etc.,but with my last attempt, I received #INVALID VALUE…
-
Trouble creating COUNTIFS
For the life of me I cant get SS to sum certain target values. For example I have an "Audit Status" column with drop down functions, some of these functions represent being "completed" and I have a sheet that I want to reference these variables as combined. i.e. Completed, Not Required, QC Complete, and Bypass QC all mean…
-
Embedded sheet in dashboard - problems
HI all I've embedded a Smartsheet sheet in a dashboard and it displays as tiles (which is what I want). I'm the owner and there are two other collaborators. They have been able to open the tile and add content to the fields but now that's stopped. They can open the tile, scroll to a field but when they start typing, they…
-
Creating Summary on the Fly
This may be a dumb question but I have a sheet Orders that is auto-updated every morning via the Data Uploader. So the list of items changes on a daily basis... sometimes the same items are listed and sometimes new items are listed as well. Is there a way I can create a summary sheet or grouping of duplicate items and…
-
Referencing other sheets
Ok I have one sheet that I have a formula in that references the data in another sheet. The name of the source sheet is "Drug Seizures" When I start my formula in the destination sheet, I click on reference other sheet, select "Drug Seizures" and then the data I want to reference. When I look at the formula in the…