Welcome to the Smartsheet Forum Archives 
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please 
Visit the Current Forums.      Discussion List 
        
        
UK - BST not recognised in Auto-System/Number Created Date? 
Hi, Can someone else from UK checkout this issue for me. I have "GMT Greenwich" selected in my Smartsheetย personal settings, but the Auto-System/Number - Created (Date) is an hour behind actual British SummerTime.ย Unless of course i'm doing something wrong? Incidently my computers system clock is correct. Regards Scottย 
 
Asset Management Template 
is there a template for asset managemen template, where you can check out and check in your asset?
 
Horizontal scrolling 
I used to be able to hold the shift key and scroll with the mouse wheel left and right across my sheets. This isn't working any more. Does anyone know how to turn this back on?
 
Submitted Web Form - User Information 
We are creating a web form to track business development possibilities. Other than adding a "Your Name" field to our web form, is there a way to see who submitted the form? On a current smartsheet where we are using a web form, I can right-click to view history, but it shows only "web form user". What we would like to seeโฆ
 
Timeline display by weeks 
Hi, Is there someway to align the week numbers in the gant timeline display with the start of a July to June financial year? I've tried the different option but the weeks seem harcoded to a calendar year. Thanks,
 
Attachment Not Found Error 
Can anyone help us fix this error in opening attachments through google drive? Note that only files uploaded directly to smartsheet from computer experience this kind of error. Attachments from google drive still works. Hope you could help us with this. Thanks.
 
Search and Replace with <null> 
Anyone know what the null value is in Smartsheet when using the search and replace function? I tried, "", <> and all the usual tricks- no go. I want to search for a particular word in a string and replace it with.....nothing.
 
Highest Value of a Column in all Matching Rows 
I am trying to find the highest value of column B among all matching values in column A. I know how to do it in Excel (see link below) but I cannot figure out how to tweak the formula to work in Smartsheet. http://stackoverflow.com/questions/21459534/excel-find-highest-value-of-a-column-in-all-matching-rows-with-screenshot
 
Custom Views 
Hi everybody, this is probably not a new one, but I've not been able to immediately identify the right thread - therefore let's try again: We've started a new sheet with some intense collaboration, and everybody has his preferred view in the meaning of what to collapse and what to extend (preferences as well change overโฆ
 
If And Formula Help 
Greetings! I am new to the forum so I apologize if my question is redundant! I am trying to combine two "If" statements into a single formula. I need smartsheet to look at two columns (Due Date) and (Project Completed -- checkbox) and determine if a project is late. I can get each half of the formula to work individually,โฆ