-
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…
-
Accessing sheets from several folders of the Home tab?
In the Home tab, how can I locate sheets in different folders or workspaces*? For example I would like to be able to access a sheet from any folder "Geographic\USA" and "Pharma\Dermatology" because, say, it is about Dermatology for the US market. * Workspaces have accesses attached to them so it might be difficult to…
-
sorting problem
My Smartsheet keeps resetting to a seemingly random sort order each time I save. I've manually resorted the sheet using two criteria (the main column--Author--then another column--Title) but when I save and refresh, the sheet resets again. What can cause this?
-
Rollup report missing rows
Can't figure this one out. Hoping someone can help. I have 6 sheets for various projects we are working on. Each sheet has at least one level of heirarchy and some have up to 3 (parent/child/grandchild?). I have used cell linking to create an "amalgamation" sheet that lists all of the projects with their related…
-
Absolute record references
Is there a convenient way to assign a fixed reference to a record that remains the same even if new rows are added or deleted anywhere above the record? Something like linking cells from another sheet, only within the same sheet, may work, too. I often want to refer to another record, but if the record number changes as…