Smartsheet Basics

Archives for January 2021

Data need to auto reflect from main sheet to subsheet
Hi, I have data in in mainsheet in text format i,e (green -5, blue-4, black-5), In subsheet if i give green , blue or black numbers has to reflect from mainsheet. I have tried with vlookup function but it is showing colour wise.... plz help me if we have any alternative in smartsheet. Thanks in advance
Order Execution for Automated Workflows
What order do the workflows get executed in? I have a workflow to move a row, but it can only be triggered right away. If that happens will other workflow items also execute? Other workflows trigger off the same change and I need ensure they don't get skipped.
Change children if a Parent meets a condition
Hi! Im struggling with this formula. I want to detect that if a parent row contains a check at the column "No", then the children turn into "Yes". So then I could create a conditional formating to crossed into gray the text in the row including the parent and the children if the condition of the check mark is met. I want…
Mindmap / Spider Web views of parent/child and relationship dependencies across worksheets
Hi Has anyone looked at or know of a way to create a more interactive dashboard of a mindmap / spider view of worksheet relationships and parent child dependencies within? I am using smartsheet to manage organisational OKR's and whilst I can create traditional grid/card and even dashboard views the OKR tools I am seeking…
Showing the Parent Row in a Report
Hello Community, I have created a report where I am only showing if there is information to show, however my Parent Row (which in this case indicated which week the information comes from), isn't being shown. Any ideas on how I can have the Parent Row from the Source Sheet show up in my report?
Can you bold the Gantt Chart View?
I am trying to bold the the labels on the timeline but can't figure out how to adjust the settings?
Created summary sheet - but cannot see the columns
Hi I created a report - sheet summary report and selected too sheets. The columns are identical in each sheet, however i do not see them available to select in the columns to display option. what am i doing wrong?
Is there a way for me to craft a report to show the freq of usage of smartsheets across users?
Hi, I am looking to create a report to show the activity of smartsheets by licensed users and collaborators? I am particularly looking to gain insights on how frequently licensed users and collaborators are using smartsheets. Or even a dashboard....
Report builder
What happen to the report builder? With New UI , it is gone. I wanted to add another column to this report See below.
Zoom/Scroll with fingers on tablet?
We have a sheet that is used by folks with tablets. Even in tablet mode, we haven't been able to find a way to zoom in/out or easily scroll through a sheet using the Windows tablet, even in tablet mode. Do you know of any settings, either on a tablet or in Smartsheet that would make navigation of sheets easier on a tablet?…

Trending in Smartsheet Basics

If you switch your Grid View to Table view, can and will your sheet stay as a table view permanently
I ask this question because i have switched my grid sheets before to table view and exited out of the sheet, then when i come back its back in grid view. Just wondering if thats normal. thanks
Smartsheet Performance Issue
By when the issue will be resolved?
Time Zones
Hi, I am getting conflicting information from Chat GPT and Copilot on whether I can change the time zone for my system time stamps. I have Pacific time showing up. We are in Eastern Standard Time. I have my setting in my profile set for Eastern Standard time, but it doesn't seem to change the created time stamp and the…

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

Watch video<

Smartsheet Basics

Discussion List