-
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.…
-
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
-
Non-owner change a report
I'm looking for a means to have someone who is not the owner of the report change the date field in the Report Builder or a means to change the date field parameter without going into the Report Builder. It appears only the owner of the report can change the search critiera in a report. Thanks Dan
-
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…
-
Report Builder - sheet won't pull if cell format is drop-down
I've built a report with criteria to pull Category field if it contains 'security'. If I format this field as a drop-down, the report won't pull the sheet. If I switch to Text format for the field, the sheet pulls into the report.
-
Date format inconsistencies, US/UK
If you copy and paste US-format dates (mm/dd/yy) into a Smartsheet while your personal settings are English (UK) (and presumably other Anglophone options), the data will retain the US format for all dates below 13. Where the date is 13 or more, Smartsheet will automatically transpose the format to dd/mm/yy. This can be…
-
Burn down
Hello, i would like to assign cost rates to different people and to auto calculate the burn rate for my projects. this information cannot be shared with the people that the prject are shared with. Is there a way to do this? thanks, kate
-
Create a new report/ count toward sheet limit?
Whenever I create a new report, does the report count against my sheet limit?
-
Resource management for contacts, not users
We have a joinery shop that we use smartsheet for each project. I have users/workers who do not need access to smartsheet, but I want to enter them in as a contact, to be able to allocate jobs to. I cant add them as a user, because they do not have work emails and I will not be sending the smartsheet emails to their…
