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.
Does anybody have experience with a report showing over allocated persons in a project? What I mean is when person A works in project X on day 1,2,3 and 4. And the same person A is working in project Y on day 2 and 4. In this situation person A is over allocated on two days: day 2 and 4. How to get this nicely reported in…
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…
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.…
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
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
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…
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.
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…
你好,我想分配成本率s 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
