Smartsheet Basics

Archives for December 2022

Reporting from worksheet with heirarchy
I have a worksheet that has parent child relationships. I have created a couple of 'helper' rows ('HELP-Phase' and 'HELP-Phase 1') to aid areport in illustrating the parent child relationships (i.e., group by one of the 'helper' rows). The % Complete and the date columns are not displaying in the 'group' heading. I would…
Does smartsheet has chinese version?
Is there a Chinese UI version of smartsheet? In personal setting, change the area to Chinese, and the interface still displayed in English. Is there any way to display the Chinese menu? thanks!
Double Dependency
If I have a task that starts when one task finishes, but needs to finish at the same time as another. Is that possible in Smartsheets? when I include a SF with one Task, and FF with another it calculates a (1) day value and finishes with the task associated with FF
May I edit an existing list of Collaborators
Hi - we have a workspace sharing list of 300+ collaborators. This list contains missing or incorrect information (first name only or changed last name etc.). Is it possible to 'edit' the list as it stands or do you have to remove and re-add the information for each correction needed? Thanks for your help.
Retaining Conversations
Is there a way to retain conversations if/when you import new/updated data? For example, if I'm importing an A/R Aging report to reflect new aging balances, but I want to retain previous conversations because they are still relevant to the collections effort.
Underlying sheet not updating
Does anyone know why my index/match formulas won't automatically update if tied to another sheet? Is this just a Smartsheet thing or am I doing something wrong? Ex.) I updated someone's information on Sheet 2, but Sheet 1 won't update anything unless I go in and give it a few seconds for the formula to run.
I've been searching for a way to make the bottom scroll bar show, it vanishes unless I scroll down.
I did a search and it seems like people were having problems in 2018 - 2020, but there doesn't seem to be a definitive answer. I am using chrome, I cannot remove extensions as they are managed by my organization. Any suggestions on how to "pin" the scrollbar so it shows all the time? The vertical one shows all the time,…
limit data access based on user login
Hello, We have a list (Excel) of over 1000 contractors with their emails and their commissions number. We want to load this list into Smartsheet and allow these contractors to login to view only their commissions number (and not able see anyone else). These contractors are external users that would not have a Smartsheet…
Peer Book Review & Rating
Hello, In our business we read a lot of books and share the knowledge among ourselves. Therefore I am developing a "Peer Book Review" sheet whereby any employee can look up a book title and add their personal review comments and rating. If the book is not on the list already, they simply add it as a new book. I created a…
Lot of time is needed to automatically update values on the dashboard.
Source sheet has been updated with new values. The updated values in the source sheet are not refreshed in the dashboard, it is taking more than half an hour to update with multiple refresh.

Trending in Smartsheet Basics

Export to PDF
Hello, Is export selected rows to PDF disabled? thanks
Workflow Subscription
Hello, I have someone who unsubscribed from the automation workflow notification and now needs to be added back. How can this be done? Thanks!
Parent and child rows
Hello, I need assistance with managing parent and child rows in Smartsheet. How can I display a milestone as completed once all of its child rows are marked as 100% complete? For example, if I complete all the rows under Milestone 5, how can I set Milestone 5 to show 100%? Thank you in advance for your help.

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List