-
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…
-
Timeline and Gantt view on a single row
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 overview of projects. We currently track in an xls document but this is static and not…
-
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…
-
Adding a new Column to multiple workbooks
I have used the same template to create a tracking system throughout our company and now have 25 sheets. I have been asked to add a column to the template and all existing workbooks. Does this need to be done manually one at a time?
-
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…
-
Sharing Report "Current User" Without Sharing Sheet
Is it possible to share a report with multiple people with ‘view’ access rights but ‘current user’ access rights without having to share the sheet? Currently, I have tried sharing with those settings several times, but the report contents are not visible to the users. When I share the relevant sheet, the report contents…
-
Converting Drop-down Date to a Date formatted value
First off, I am using Control Center to build out projects that are dependent on a central worksheet, "Weeks of…" as a drop-down source list. The "Weeks of…" is contained in a Portfolio folder in the Admin workspace. Secondly, I have a worksheet, "Weeks" that contains a number of dates, DATE. In this worksheet I have an…
-
Electronic signature in document
I’m having service provide agreements for different clients, how to implement a e-sign workflow in smart sheet where a document is generated and sent for signature to the clients.