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
Sheet Schema & Report Schema Documentation
Hi, I would like to recommend the following enancement. Please could the be a way to export as an Excel or Google sheet the Sheet Schema. This should contain all the information and properties of the sheet, As per the Properties Dialog box from the Sheet menu Plus all Field: * Column Name * Column Type * List Items * Also…
Counting Rows
I have a list of projects divided into sections. Each section can have projects that have sub projects. When I use this formula on a section header ="Current(" +COUNT(CHILDREN()) + ")" my result looks like this: Current (24). However, the count does not include the sub tasks. How can I write the formula so that it will…
Archiving Workspaces
We have just started using Smartsheet to manage our IT Programme. Each project has its own Workspace. I am just investigating the best approach to archiving projects when a project has closed. We will need access to view the project information from time to time but would not want the Workspaces to clog up the current…
Lookup returning no results
I am trying to have a LOOKUP formula return a result based on the status of a checkbox. I have tried to forms - one by having it look for "0" and one by creating a secondary column that reads the checkbox and returns a "Complete" or "Not Complete" status. Neither will return a result. I have attached a screenshot here…
How do I create a condition when a specific drop down item is selected that an email is sent ?
Using a moble app, VSI (vehicle safety inspection) I would like the ability to have an email sent to my Fleet group that alerts them when certain drop down items are selected. For example, if there are issues with the brakes and they select "Problem, Requires Attention" or when they have an expired registration or…
How do I remove erronous contacts from the All Contacts repository?
I am the Admin on our company account. I have updated the User Management and My Smartsheet Contacts with the most accurate employee list. When I am assigning out or updating tasks, there are still erroneous and duplicate contacts in the All Contacts list. How do i remove them to avoid confusion? Thanks!
How to calculate schedule % updates in Smartsheet
Hi, I use smart sheet for tracking my project progress. i would want to add one more column similar to % complete to calcuate my schedule percentage based on the number of days complete till date divided by duration. i added a column with percentage updates as per schedule however, these percentages do not roll up to the…
Formula Issue
I am trying to search one column and if it returns "travel agency name" then to add all data in "# of RPS". But I keep coming up with an error. Any suggestions? Thank you.
email alerting + webforms
Hey All Hopefully someone can help, i have an interesting requirement. i am looking at using smartsheet as a means of recieving "errors" from clients and then actioning the investigation. I would like to be able to create kanban lanes in card view ( easy ), i would then want to create a webform that would feed into each…
% of children
Hi, I want to calculate % of checked children in the sheet below, can anyone help me? https://app.smartsheet.com/b/publish?EQBCT=41482d287b58426b801642f8c4cd31f0 Niclas
