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
Report by User logged in?
Is there a way to create a report that filters the underlying sheet by the user running it? For example in SharePoint, you can create a view, so that whomever is viewing it will see just their records according to a column by entering a filter in the view setting the column to equal [Me]. Is there something similar in…
Repeating the same task across multiple months
Hi I am building task lists for our global team for the rest of 2016 that I will be showing in a calendar view for them and setting up alerts and reminders on what has to be completed, when. I have a number of tasks that need to be perfomed every month; how do I set these up to repeat? The only way I can think of how to do…
Formula that updates a cell in another column
Does anyone knowif there is a way to have a formula in one cell update a cell in another column? Currently I have a formula for a check box column (Task Complete Column) that checks the % Complete and if the task is 100% complete the check box is checked automatically. eg: (=if ([% Complete]4,1,1,0) This updates the check…
Reporting: Linking two sheets on a common column
In reporting I have picked two sheets. They have a common primary column name. The columns do consolidate (i.e. there is only one column with this name). But...I have two rows for each, i.e. row 1 is from sheet 1 and row 2 is from sheet two (of course, row 3 is from sheet 1 and row 4 if from sheet 2). Is there anyway to…
Formulas and data
I have a fairly simple sheet used to track travel costs by subcategory and estimate/actual comparisons. I want to add new data lines into the sheet inside the subcategories and have the subcategory total formulas automatically adjust to the larger data table. When I try it the formula data range remains static, referencing…
Nested IF for a status column based on a date column
Hello, I have a list of employee certifications where the certification name is in one column, the certification expiration date is in another and the status if this the 3rd. I have a column called NETDAYS where I calculate the number of dates in between today's date and the expiration date. The formula I can currently…
Web form notification
I have set up a sheet with a corresonding web form so people can order items that I will need to purchase for the company. What do I do so I am notified immediately that a Web form has been submitted and the request has been added to my Sheet?
Line breaks not carrying forward in Sights
I have cells that each have several short topics that I separate using line breaks (ctrl-enter) to make the text more readable. For example: --------------- topic 1 topic 2 topic 3 --------------- When display these cells in Sights using the Sheet widget, that formatting is lost and the topics all run together. This is the…
FEATURE REQUEST: Folders in Attachments
We often have 10 or more files attached to a single row. Would be nice to clean up the clutter by having folders in the attachments window.
Is it possible to freeze and unfreeze rows like you can with columns?
Is it possible to freeze and unfreeze rows like you can with columns?
