Using Smartsheet
Want to know more about using forms? Interested in better understanding automation? Want to see what's possible with dashboards? Post your question or discussion to Using Smartsheet.
Discussion List
-
Dynamically populate a drop-down listIn Using SmartsheetHello, I have two related questions: Is it possible to dynamically populate values in a drop-down list by referencing values from a specific column from either same sheet or another sheet? Once a drop-down value is selected in a web for…
-
Taking quarterly goals and putting them into SmartsheetIn Using SmartsheetI have a general table I use to keep track of goals for a sales team. I think they're relatively simple, but I'm having a heck of a time trying to get them into SS. The things I need to track: Goal value - numbers, for example $62,000 Actu…
-
How to Create a form that updates part of an existing record?In Using SmartsheetI have a request tracking sheet where the requestor fills a form to register a new request (record/ row). Later in the process, I need the person actioning this request to open a form that allows selection of any request (record/ row) to b…
-
Rename sheet does not update Sheet Name (system column)In Using SmartsheetIt appears that renaming a sheet is not updating the sheet name (system column) value. Can anyone confirm that renaming a sheet does not update the system column value? Thanks, Mike
-
Is there way to Update an Existing Entry/Ticket Number via FormIn Using SmartsheetIE i have an Automated Number populating in one cell (Creating a Ticket Number) What i would like to do is in Forms. Create a toggle with logic that says if its new then create a new automated number. If it is an existing number then look …
-
connect a cell of a grid with another in a report.In Using Smartsheethi I can't connect a cell of a grid with another in a report. is there a way
-
How do I stop a report showing two names, when only one name should appear?In Using SmartsheetHi, I have a column titled 'Assigned To' and is only set to only allow one contact per cell. When I run a report and use Group By 'Assigned To' it rolls together some cells which shouldn't be rolled together. Weirder still, if I use the a…
-
Live Data Connector (ODBC) and Microsoft LoginIn Using SmartsheetHi, I'm used to get data from Smartsheet to Excel thanks to the Live Data Connector. However, I can't find a way to use it with a Microsoft login. When the ODBC driver asks for credentials, the only way to access data is through an API key…
-
Update request defaultsIn Using SmartsheetWhen you create a new update request from a specific row - there are many preselected columns that you can add or subtract from. Is there a way to change the default selected columns? Currently it appears to be any columns not hidden - whe…