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 2017 Posts
Archives for December 2017
Discussion List
Is there a Japanese or Japanese company here?
Hello there, This is Kikuchi, working at a Japanese company in Tokyo, Japan. We are going to start smartsheet in our company and wondering if there are any Japanese users here? so that we can exchange the questions or experiences. Please let me know if you are a Japanese!! Thank you very much for your attention. Best…
Top Level of Sheets in Report
Hi. The top level of my project sheets contain the overall percentage and status and date range of all its child tasks. How do I display just this top row in a report? My current workaround is to have a hidden column that a mark and have the report builder only show the row with that mark.
Adding Report Widget
Any tips please? I'm attempting to add a report widget to a sight sheet. I'm the owner of the data I'm trying to access but it says I can only select reports which you are Admin.
Default Styling for Form Submission
Is there a way for form submissions that get added to my sheet to automatically adhere to the stylings of the sheet? It's been a little annoying to change the fonts and sizes each time...
Referencing formula for other sheets?
Is it possible to build a formula that references other cells/sheets into a new sheet? I am trying to create a sheet that would sum values from another sheet into a new one to build some stats. Because the source sheet is generated using the SmartSheet/JIRA connector rows are automatically and constantly being added, so I…
Formula Inquiry
I am trying to get a formula to automatically apply a number (vehicles complete column) when a date is filled in from a linked cell in another sheet (completed column), see attached photo for reference. The cell I want to be auto filled has a sum children formula already in place. Is this possible and if so do you have an…
Using "Created by" as "Assigned to" for Resource Management
I'm using a web form to collect vacation request, etc. and added a System-generated column to automatically add the Created by. The form is only available to registered Smartsheet users. Now I want to see these absences in the Resource View and to do so I need an Assigned to column. Is it possible to somehow connect the…
Formula to move data to another column
I would like to move data from one column to another. Is there a formula that can do that? I may append to existing data or replace it depending on options. If there's no formula, how can this be done manually? I tried cut/paste, but it did not work.Thank you.
Change week start day for resource views
Hi, We have changed settings everywhere we can find to have our work weeks start on Mondays. This has worked for sheets and reports but we can't find anywhere to change the start day of the week for resource views to Monday instead of the default Sunday. I can change the time period to start on a Monday but the following…
While moving row to new smart sheet it re orders to a new column.
Why is it linked to this new column how do I change it. It is greyed out on my sheet. I have all admin rights