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
"Publish User is now viewing this sheet" displays on unpublished sheet
I briefly enabled publishing on a sheet by clicking on the "Publish" tab, selecting the "Edit by anyone" slider, and then selecting the "only available to users in the owners account" radio button. Publishing the sheet didn't work for what I was trying to do and so I decided to turn it off. I did so by clicking the…
Feature Request - Group setup at user creation
Hello, I think it would be great if, when you go to add a new user, a window was available that would allow you to check box which groups you would like to add that member to. Currently, if I create a new user or group of users, I have to go into each group individually and add the new users. This is time time consuming,…
Automating text based on information in other column
Is there a way to format something like this: If column A is True than column B says blank? The reason I ask is that I have a report with site in one column and the next column should have id. It would be much easier for the id to popluate based on the site in the first column.
New to Formulas - Need help with Text Answers
I have tried to create a formula using three options being 1. Does not meet Insurance Standards, 2. Meet Insurance Standards 3. Exceeds Insurance Standards for a particular series of questions. If you choose "Does not Meet Insurance Standards" then then next column Score will also populate 1 and the cell will highlight…
Help to understand webhook callback JSON
API Webhooks sends Sheet column update callback JSON with multiple row and cell objects as marked updated. How do you find the correct rowID to get column values for the updated row? For example, I changed the status of one row column from A to B and received the following JSON from webhook callback: Body:…
Sage Integration
I would like to export data (or connect via ODBC) from Sage, i.e. sales order number, customer info, item and have this upload to an existing sheet. I have a web form for users to record data prior to completing the sales order. When they access the web form, I would like them to be able to select the sales order and then…
Predessors
When I use the SF dependency type the line I am working on doesn't use the target line's start date as a finish date, ideas?
Ordering Search Results
Is there a way to order search results from the Current Sheet by their line number within the sheet?
Missing smartsheet template
When Smartsheets launched thier new card view, they also had several templates they provided. I downloaded one that was a ticketing system that tracked average submissions per day, etc. I cannot locate it now. It had some fairly complex formulas that made the tracking work. I have attached a screenshot. Anyone notice this…
Formatting trouble
If you have created conditional formatting to color alternating rows a different colors, how do you format the document to automatically adjust colors when a new row is added?
