-
Dynamic dropdowns - Waterfall request
The Contact List, Dropdown (Single Select), and Dropdown (Multi Select), are useful tools to control data entry. The problem is they require a lot of maintenance. Through Bridges, we have a sheet that is populated with information from our ADP. It contains all of our employees. Using a Contact List column and selecting the…
-
View formulas globally in a sheet
Both Google sheets and Excel have a shortcut (CTRL+~) that allows you to toggle a view that shows all the formulas in the sheet at once (that is, the cells change from displaying values to displaying the underlying formulas). I find this very helpful to: - Discover which columns I want to shade grey to indicate that they…
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
COPY ROW - How to sort destination sheet and display NEW row at top
Hello SS Community, I am using a COPY ROW Workflow to add new row to a destination sheet. However the new ROW is always showing at the very bottom of the sheet and user needs to always scroll down. Is there a way to set up the destination sheet to sort and always have the NEW rows come in at the top of the sheet? I have a…
-
Import data directly into existing sheets in table view
February 26, 2026 We've all been there — you have a spreadsheet full of data sitting on your desktop, and you need it in Smartsheet. Until now, importing a file meant reverting back to grid view. Now you can stay right in table view and import your data without ever leaving the view you're working in. Now you can import…
-
Timeline and Gantt view on a single row
https://us.v-cdn.net/6031209/uploads/DBE28QGHXGI5/timeline-and-gantt-single-row.docx As per the attached, I would like to a single row, with color coding, to reflect the various phases of a project in Timeline view and Gantt view. The importance of this view is to give Sr Leadership and Stakeholders a simple, visual…
-
Any suggestions for keeping infrequently-visited sheets/reports/formulas updated with current data?
Hi everyone, I have a scenario that worked well for 3 years, but in the past 6 months or so has become unreliable: As part of a templated toolset, I have a couple of 'worksheets' (where users are visiting and making updates), a 'calc sheet' that's pulling information together from these worksheets via index formulas with…
-
Why is the sheet name not in the browser tab when in Table view?
The sheet name is in the tab in Grid view, but not Table view, making it difficult to locate a particular sheet when multiple tabs are used. Is this a design oversight?
-
Creating an Asset from Sheets folder
From Sheets folder it is no longer possible to create an asset directly from this location. The dropdown menu has been removed from Actions It is now required to right click on Sheets folder No visible dropdown menu for creating an asset. Now required to click on Create taking the end user to this screen. Options to create…
-
Project Attachments Need to be on dashboard via SCC
I am using SCC to auto provision projects. One of the asks is to have project specific documents be in the project specific dashboard, these documents arent made available until after the project provision. Currently since i am the Smartsheet person, i am sent that data and need to do this manually, however I want them to…