-
Previous sheet opens!
Hi all, has anyone experienced the previous selected sheet opening when you click on a different sheet to open in the folder view? I've started updating the wrong sheet several times over the previous few days because of this... Any ideas? Regards - Roland
-
SUM Function is not working properly
Hey Everyone, I'm currently working in an area where my SUM formula is simply not working, my formula is =SUM(ColumnB127:ColumnB133) and it continues to return a value of 25. Below I have provided a picture. I even thought it may have something to do with the value's being linked, and pulled those values into a separate…
-
Help wanted
We re looking for a subcontractor to assist in design and implementation of construction scheduling, task management, and resource allocation for a small construction company. Presently, working with Microsoft Project and need to revamp our solution with Smartsheet to be more detailed, efficient, and useable.
-
SIGHT Metrics
I am part of a PMO and we track all projects on one sheet. The PMO covers multiple lines of business within our organization, thus I have a Sight set up per line of business. In each Sight, I would like to be able to show the number of projects in each RYG status. What is your recommended approach for doing this? I've been…
-
Change which Email Address is used when sending emails
I have a sheet in a workspace that I want to send as a PDF attachment on a reoccurring basis via email. When it sends - it is FROM "my name via Smartsheet" and then user@smartsheet.com. I want it to come from another name - not my name. Is that possible? I assume it is if I change my name on my account it will do this…
-
Multi-Sheet & Few Clicks
I have an assessment sheet where 2 different rating columns are linked to the rating key at the top of the column. Would it be possible have the Rating Key Sheets linked or formulated so that when a rating is selected on the key, it'll enter it into the cell on the Assessment sheet? Does anyone have any suggestions / best…
-
Information in cells mysteriously disappears
When my smartsheet is open and I am not doing any editing, I find that cells mysteriously empty themselves and are marked as changed. The RYG balls also just disappear in the priority column and are marked as a change. Sometimes it is impossible to restore the information as it keeps reverting to being deleted. Only one…
-
Freeze top two rows
Is there a way to freeze the top 2 rows of a SmartSheet? I have data in the 2nd and 3rd row that corresponds to the header and I'd like to maintain visibility but have yet to find a way. Thanks!
-
create a location updated index from 1-10
I need to create a count of 1-10 that always stays at the top of the column in the correct order even when the sheet is sorted and when web forms are used to input information to the top of the sheet. Sounds simple but I have no clue how to do this without drawing a circular reference and without the ability to reference a…
-
Linked Sheets and Dragging Rows
When dragging rows to another sheet, is there a way to keep the information from the Parent sheet which to information is being pulled from? This would obviously automatically create linked cells back to the parent sheet that the information is dragged from. Is this possible? Current Process: My company is basically trying…