Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Archived 2016 Posts
Archives for June 2016
Discussion List
Sharing more than I want
It appears that when I share my report everyone can see all of my other sheets. How can I prevent this? Thanks.
Card View Labels
When I switch to Card View I am unable to see any labels for the detail on the card. Using the example below I would not see the text units: mearly the data 21100. I would like the lable to be the column name. Is this possible? Or is there another way to set this information. Thank you
Reporting based on % of work
I need to have an initial graph of the amount of planned work schedulled for each week of the project. The "X" axis will have each week and the "Y" axis the % of work to have done. I am sharing a graph as an example. The blue line will be the planned baseline project. The red line the real work on a weekly basis. Any ideas…
Formulas in Smartsheet
Im trying to get a formula to work in smartsheet. Can anyone help me out? =IF([Travel Type]1, "craftworker"), ".3", ".4") I want it to apply $0.30 to the cell if the travel type selected is craftworker.
Lock a Sheet/Tab on main view
Not sure if this was a previous discussion item, but wondering if there is a way to lock a specific sheet to always show up in your main SS page when opening.? I made the sheet a "Favorite" but it always seems to get closed
CardView
Can I merge more than one smartsheet into a single Card View?
Card View Colours Colors Color
Hi All, What determines the colour of the TAB in Card View? Can this be automated - conditional formatting etc?? Or manual choice only?
Extract Numbers from Text and convert to Text
Hi, I have many rows of texts with each having a number within brackets. I would like to be able to extract the numbers from the texts, convert to number and sum them to get the total. I understand that the VALUE function can be used to convert text to number. However, I'm not sure how to extract the numbers from text. Eg:…
Publishing Card View is important
Card view is great, but I want the benefits of publishing in Card View to those who should not be given access rights to my smart sheets. I want read only publishing for Carv View... When is it planned to be available?
Allocation of Resources
How do I allocate multiple people to one task? Ive ready that you have to create multiple lines for the same task if youi have more than one perosn doing the same task? (Different from MS Project)