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
External clients access to view worksheets
I have created a project program which our client was able to view, however she now needs a"Log-on" & Password to be able to view my sheet. I haven't changed any settings, so I need help to let her view the project program?
Duplicate Values in column
I am having an issue with a sheet where we had changed some of the values in the dropdown of column properties, but because the old values were used previously, unless a user selects the dropdown, they can start typing and select the old value. It creates an issue when trying to analyze the data. even when we override the…
Recurring Update Requests by Contact
I have a sheet that serves as a team pipeline report and I would like to have a weekly update request where every row assigned to a specifc person is included automatically in the request. Each row has one designated person in charge and I would like for them to receive the notice to update each of their projects in the…
Average of RGY Children
Hello, I currently have a long long formula to look at the RGY balls of the children of a task and create a color based off of the sum of yellows vs. red vs. green and which one is greater than the other (see below). =IF(AND(COUNTIF(CHILDREN(), "") > COUNTIF(CHILDREN(), "Yellow"), COUNTIF(CHILDREN(), "") >…
In Cardview - Best way to remember if you have updated the card.
We use cardview to get the status updates from co-works. As we work through the "cards" it becomes hard to remember which cards we discussed and which one we haven't. What is the best way to deal with this issue? It would be great if in the upper right-hand corner there was a bright color (maybe blue) letting me know that…
When I access Help resources it asked me to log in again?
When I'm logged in to Smart Sheets via my Google account and I try to access anything in the help menue it shows I need to log in to access those pages. When I authenicate again it takes me to the smart sheet application. Cycle just goes in circles. I have my profie set up in community. Need some help to figure out the…
Webform hosted on another site
Hello I've created a webform that I've inserted as a iframe on a wordpress site, which works. But I wonder if its possible to create a form which uses your API to create a post on a sheet instead, which is hosted on another site, like my wordpress site?
Blank cell in auto numbering
How do I remove auto numbering from one cell in a column so it is blank and numbering continues in next row?
Account ownership transfer
I may (or may not be) putting in my resignation very soon and I need to understand the best way to accomplish a complete account transfer. I am the owner of our work Smartsheet account and we have 6 licensed users. I am potentially going to a competitor so it's possible that I get escorted out. If that happens, I want to…
sort functionality
Please make it so I can sort a subset of rows and not just all rows