-
Auto fill gaps
Good afternoon, I would like to know if it is possible to autofill a gap by using a code in a formulary. For example: Code number 5678 - WALLMART STORE When the code is entered automatically a gap is filled. Is it possible ? Regards,
-
unintentional deleting of cells
My cells are being deleted simply by clicking on the cell and staying on the cell for about 3-5 seconds. How do I stop this nonsense? I have logged in an out several times. The undo buttom does repair it but obviously that is not a fix. Any suggestions?
-
Formula help please (Simple if statement!)
Good afternoon, I am having trouble with an IF statement returning a date. It works fine if I ask it to display a text column instead of the date column so I know my formula is correct. Basically I have added a column with a display on calendar or not, so a simple Yes or No drop down. If it is "Yes" display the Event Date,…
-
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.
-
Graphical display of the indent level
One feature I really feel the need of is the possibility to have graphical display of the indent level of the rows. Since I'm working with big files of data, sometimes I don't have the father row and the children ones (which have been indented) on screen, but I have to scroll the sheet. When working with multiple levels of…
-
Attaching a Smartsheet Project Charter
I have a smartsheet that lists all of my active projects in a one line listing. I would like to attach the project charter to each project in this sheet. Is there a way to do this besides exporting into excel and then attaching?
-
Push Merging - Is there a way to push a record form smartsheet to a Merge function
Hi All , Calling all Merge Experts - Google docs or another applicaiton. I am looking to build a quicker more accurate solution. I have a GDoc template created, I have a list of data that I merge from. Presently I have to go to the GDocs Document to then select 'add ons > smartsheet merge" to then Select the record I wish…
-
SmartSheet Reports have limitations that make them useless for business
We recently learned the hard way that there is a limit to how many sheets a report can access! We use the report feature to create individual task lists throughout our company. Each task list searches all sheets for names in an Assigned To column and refines the search looking for a value of "Needs Action" in the Status…
-
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.…
-
Formulas and Data Rollup
Hi, I am in the process of putting together a sheet that logs the amount of production each day. As a bit of background we are an aggregate manufacturing and contracting business and what i am trying to do is have a sheet that tracks the amount of production of each product per day. I have created a sheet with all the…