-
Monday of date
I have an installation date column and a "week of" column. In our "week of" column, we keep the date of the Monday before. As an example, if the installation date is 1/19/17, the "Week of" column should be 1/16/17. Or, if the date is on a Monday, (Installation 1/23/17), the "Week of" column should be the same as the…
-
Is there a way to make my folder structure setup the default for everyone on our account?
Thinking of this like file explorer so that all of the sheets are organized rather than in one long list for the users I add / share sheets to throughout the team. thanks
-
Autonumber refresh for new year
I use a formatted autonumber column to record a new Reference Number for each new entry in a Smartsheet. The format I use is CR{YY}.000 where 000 started from 001 for the year 2016. I want to continue this format into 2017, but I want the 000 to restart from 001. Any thoughts ? My list of rows should end up like : CR16.001…
-
IF/AND Functions
I am trying to create a sheet that will auto update a number in a cell using multiple IF AND statements. Is it possible to have multiple IF(AND statements in one cell or what is the format? When I have one statement it works properly, but I cannot figure out how to have it work with two or more. I am not worried about the…
-
Including only the most recent comment.
Hi there, Within the "Print Setup" for .pdf reports, under "Options", "Include comments" checkbox....when selecting this checkbox it prints out the full set of comments which is fantastic but can make the report quite lengthy, especially over time. However is there a way, or is it possible in future upgrades to select an…
-
RYG Balls Not Displaying Anymore
I built a report off of a seperate smartsheet that had RYGB Balls to help identify that status of the entry. The RGYB Balls are no longer displaying as a ball/bubble but instead as text of the color. I am not able to change the status of these entries for the rows that have the color text instead of the bubble. It will…
-
Managing large number of filters
I manage product releases and have multiple columns that I need to filter by (department and owner). I have a variety of entries in a given column, but I cannot find a way to click the dropdown at the top of the column and select one of the values within that column (like how filter works in Excel). Am I forced to create a…
-
Engineer's timesheet
Has anyone created a timesheet for tracking/recording billable hours towards specific projects.
-
dropdown menu in a column in webform
hello everyone i am brand new user in this community trying to familar with this software. so far looks very promising. i have a question like how to make multy forms in one web form like i want to generate form in which in second line there should be multy option to select one and then under neath line will change…
-
Sorting recommendations when you have summary rows on the top on your sheet
I am experiencing issues when sorting a sheet and have summary rows at the top. For example, I created summary rows on rows 1 through 10 with formulas and totals, and when sorting, my summary rows get lost in the sorting process. Do you have a workaround to prevent this from happening? Ideally, I would like my summary rows…