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.
Discussion List
Exporting into Excel - how do I create a timeline?!
Hi, I need to export my Gantt chart (timeline) into an Excel sheet to share within the business. but this currently can't be done in Smart Sheet. What workarounds/other options do I have? I absolutely have to show it visually! Thanks in advance!
SUMIFS Function with Multiple Column Sum Range
I want to sum values over a two column range using multiple criteria but when I include more than one column in the sum range I get a #MISSING OR INVALID PARAMETERS error message. When I back off the sum range to a single column it works fine. Is the sum range in the SUMIFS function restricted to a single column?
How to allow different collaborators in one tasks sheet to edit or update only the tasks (or rows) a
Hello So, in a project I'm supervising, I built a tasks sheet which contain number of tasks assigned to different collaborators. I was expecting that every collaborator will be able to only update the rows which are assigned to him only as I specified in the Assigned To column. But what I found is that everyone with edit…
Auto assign helpdesk queries
Hi, I have set up a webform to collate helpdesk queries. Every query is one of 6 types (one of the fields on the webform is a drop down to select the type of query. I would like to automatically assign one of four people to handle each query based on which of the 6 types the query is regarding (there is a mapping of type…
REVERSE A WEB-FORM
I would like to be able to select a row and the information held in that row populate a web-form so that I can send the completed form to another user.
ticket system \ Sharepoint integration with Smartsheet?
Hi all, My projects team are using Smartsheet to manage company projects. We now need to also manage some company’s tasks in a tickets system. Normally the company uses SharePoint for the internal ticket system. I would like my team to use only 1 system, Smartsheet. The issues are: 1. I couldn’t find and formal…
Formula to calculate week number or week commencing date
I have a column of dates in a smartsheet, and wish to insert a formula into another column what will tell me either the weeknumber (e.g. Excel WEEKNUM formula) or the weekcommencing date. Does anybody have any suggestions how to acheive this?
Formulas Dissappear
Is there a way to keep the formulas from dissappearing? I have a formula set to check if the checkbox is checked but if the checkbox is checked independently from the main checkbox then the formula seems to dissappear. Also, is there a way to view the form as another type of user, ie...viewer, or editor? Thanks YouTube of…
Feature Request: Live column dragging
Instead of the grey preview that shows up when adjusting the width of the columns.
Filter Calendar View?
Is there a way to filter the Calendar view WITHOUT having to switch back to the grid view?
