-
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.
-
Unicode Text Symbols are extremely useful
Please send me an email if you would like to be added to the workspace. kriswalsh@gmail.com I love Smartsheet's native symbols and use them all the time. That being said, there are times when I wish I had more options or flexibility with them. I am sharing the following with the hope that: 1. Someone finds it useful. 2.…
-
report repeated names
Is there a function to allow me to put together a report that identifies names that appear on more than one row in a given column. In this case I am trying to bring out information on people who appear more than once in the name column, and then have the report show certain fields for those
-
Tracking Assets by location
I am not sure if this can be done in smart sheet. I need to track assets by location. There with be up to 50 assets by location and several thousand locations. I would also like t have the ability to add the bulk of the items from a location kit as all have common items with a few variables as to how many of each. All…
-
Moving rows
Is there a way to move rows from one sheet to another and keep all the cell formulas that go with it?
-
Using formula to copy row to new sheet as a child row
We have created web forms to retrieve new client information and new project information. Both forms contain the Primary Column "Client Name". I know we can link cells from one sheet to another. But what I'd like to know is if we can set a formula (or link a sheet) so that when a new form is submitted (and it is added to…
-
Can I eliminate everything from a cell except for the end?
I would like to create a new column that will essentially copy over information from a different column but will only take the last few digits. For example, the first column will say "John's Business 290583958". The last digits would be the Sheet ID of "John's Business". In the second column, I would copy over the…
