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
STS dots
Is there a way to add another color dot to the Drop down, or select a new one with 5 colored dots for the STS column?
Outlook integration
Can you help me get the Outlook to work? I click on the link to add app and it just gives me a blank page? is there a video on EXACTLY how to set up?
Removing Parent Rows from a report
Hello everyone, I am using Smartsheet to manage several projects, all on individual sheets, with a high level role up for managers. We are trying to create a report that goes through all of the projects in a certain workspace and looks for tasks that are past their due date, then outputs the project name, task and who it…
Transferring Smartsheet from one account to another
Would like to know if I can transfer primary ownership and control of a specific Smartsheet from my account to another. Thanks in advance for any help you can provide? David
How do I use a wildcard or "contains" in my if formula?
For example, the cell reads "Smith, Johnny" and I want to write a formulat that returns a result if the cell contains "John". Normally I would use =if(cell,"*John*","YES","NO") with the wildcard * before and after John. But this does not seem to work in SmartSheet. Do I have the syntax incorrect? Thank you!
workflow automation
Are you considering to incorporate workflow automation to Smartsheet ?
Limit rows in a sheet
Is there a way to limit the number of rows created by a form? I want to use a form for people to register for a training event, but am limiting the number of attendees to 50. Is there a way to automatically deactivate the form when 50 rows exist in the sheet?
Editing uploaded files
I am project managing construction jobs and have been given the task of auditing contractors whilst they are on site. I have uploaded the audit forms onto smartsheet as an attachment and I was hoping to edit them while I was on site without downloading them and re-uploading them. The files I am uploading are word…
Counting all siblings below a master Parent
Hi, One of my sheets has a master Parent and have several parents and childs below. What could be the formula to count all items below any Parent, which counts all parents and childs below? Thanks in advance.
Is there a way to set a default sort order on a sheet?
I have an open issues list. I would like it sorted by open/closed, then by priority. I can do this manually each time, but I would like that as the default anytime someone access the sheet. Is this possible? Thanks. Wayne
