-
Using "Contains" for Numbers
I'm attempting to filter a column with the following type of data: 10007789001 10007796003 10007789001 10007789002 10007801001 I tried to filter this column using "Contains" 7789. I expected every row with 10007789001 and 10007789002 would be shown. However, Smartsheet indicated that 0 rows met filter criteria. This…
-
Wrong sorting order with numbers smaller than 1
Hi there, we are using a column "Estimated work in days" with a DropDownList with the values: 0,25 0,5 1 2 5 10 n.a. t.b.d. Please consider "," here in Germany is the decimal separator. Sorting the rows in a sheet leads to an order were rows having 0,25 or 0,5 are listed below (or on top) of t.b.d. In reports the sorting…
-
More sheets open that the top ribbon can show
I regularly have 10 sheets open that I'm working on at any given time need to QUICKLY switch back and forth and clicking the ... and clicking to the sheet there takes an extra couple of seconds that adds up when you do it 100 times per day. I'd like to request an enhancement to have multiple "rows" of tabs, instead of a…
-
Freezing Columns Creates Two Scrolling Panes
Being used to Excel and setting up Panes for large sheets, we were delighted to find that if a column is frozen well to the right in a sheet, the "freeze" line can be drug to the left to make both sides scroll horizontally. Hope this is a helpful hint for someone searching for Panes.
-
Report missing row after additional row added in smartsheet
I have a smartsheet set up with all transactional sales for each region (including status, probability etc...) I also have a report written looking specifically at just one region. However, when a new line/row was inserted in the smartsheet the detail (new line) has not fed through to the report. The totals are correct…
-
Question about creating a pricing sheet with multiple linked sheets
Hello, New to SmartSheet and have only been through the basic training video. I understand this product is super powerful and can do just about anything related to spreadsheets. I just wanted to reach out to the community to see if what I was looking to accomplish is something the group feels is obtainable before I keep…
-
Excel template that generates (automatically) formulas for smartsheet
Hi Guys, I made an excel (macro enabled) that allows to my team create projects easily and faster. The file generates (automatically) formulas for smartsheet. I publish the example here You can register time here This is the video The video is in spanish, I will translate it in the coming days. Regards, Álvaro
-
Customize Metadata for Rollup Project Plan
Hi Community: I want to see if anyone would know the way how to customize the metadata for the rollup project plan. I would like to add more "columns" to allow filtering in the Portfolio Scorecard when my projects rolls up into the scorecard.
-
Adding a divider to split data
A co-worker who has since left the company created a sheet that has split the information on the sheet into 2 sections, so that it is separated by a divider. I've attached a photo showing the divider: Anyone know how to do this?
-
160 character limit in field (used for sms)
Is is possible to set a l60 character limit to a field? The reason for this is that we collect texts from users (mostly by web form) that we will use for sms, but usually they write more than 160 characters which leads to extra work.
