-
can I prevent new rows from being entered?
Is there a way that I can prevent new rows from being entered by the users?
-
Avoiding double entry in multiple sheets.
I currently use Smartsheet for one purpose and still use Excel spreadsheets for another purpose. I have however hit a problem and wonder if anyone can help and provide a solution. Currently I have a sales spreadsheet for each employee. Each sheet contains a range of data. The range is the same on every spreadsheet and it…
-
How to find out how many columns am I using in a sheet/report
Good morning, I looked through and didn't see this question, so if it is posted elsewhere, my apologies. Is there a way to know how many columns you have on a sheet without having to manually count them? I know I have a few sheets with anywhere from 25-50+ columns, but I've not found a way to get a count automatically. Not…
-
Tabs on smartsheet
I probably know the answer to this, but is there a way to create tabs on one Smartsheet document? I am uploaded an Excel workbook with about 30-40 tabs on it. I am afraid that I will have to create 30-40 individual smartsheet documents. Thank you.
-
Smartsheet Directory
I made a directory listing all of our smartsheets with a brief discription of the sheet. I made the name of the SS a hyperlink that takes you to that SS. I then shared the directory with my office. My problem is if there is a sheet someone in my office wants to access but the sheet has not been shared with them then I want…
-
How do i create a multiple line column heading?
With Excel, we can enter a column name, and create a line break with the Alt-Enter key combination. How can we get the same effect (one or more lines in the column names) with Smartsheet?
-
How can I tell how much data a sheet is using?
We have a particular sheet in which we're attaching short audio clips. However, I know that audio can eat up space rather quickly, so I'm wanting to know how much space that particular sheet is using. I've clicked on the properties, but don't see a data total within that area. Blessings, Loann
-
filter shows removed items
I have a sheet which contained among other things a column which had abbreviated shortnames for countries... like IN for India, AU for Australia... At certain rows, it has also been updated as IND & AUS.. i was in the process of changing the abbreviated names from IN / IND to India & AUS / AU to Australia.. From the column…
-
Pull Down Menu Options from Common Source/Sheet
All, I am using Smartsheets to track time, and have run into an issue that I have to believe there is a workaround for. We need our associates to track their time with specific job and client IDs. This can be done by making the time tracking entries show as a pull down menu of codes. But, when we get new jobs or clients,…
-
Setting Rules and Conditional Formatting
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…
