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
Target Communications
How about introducng the conept of targeted comms within Smartsheet. For example if you @ mention a collaborator anywhere within a sheet they will receive some form of notification either via email or a pop-up within Smartsheet.
Counting Checkboxes of all Parent rows in a sheet
We have a sheet that has a multiple level hierarchy. One of the columns is a checkbox and I used the formula ="" + COUNTIF(CHILDREN(), 1) to count the number of checkboxes below each parent row. This created the number of checked box in the parent row. Is there then a way to count all the numbers in the parent rows (to get…
How do I highlight columns on a gnatt chart
Hi Please could someone help me with highlighting columns on a resourcing sheet I have just created. I have the data on the rows and need to show when people are absent during the month by highlighting it. Many thanks Audrey
Is there a way to remove someone from Resource View without removing them from a project?
Unfortunately people come and go. They are assigned tasks, work on projects, etc and then if they leave, they need to be removed from the Resource View. Reassigning future tasks is acceptable, but we need the history and want to keep them listed on completed tasks. Is there a way to do this? I would rather not have to…
Automate a cell to clear
Hi! I am creating a database for researchers to borrow equipment. We want as much of it to be automated as possible. When an item is marked as 'returned', a green RYG ball shows up in the availability column. I would like other cells to clear automatically in the row when the green ball activates. How can I write a formula…
combining project plans and task lists
I am working on a fairly complex project plan with a large team. To keep track of miscellenous tasks, we also have a tasklist ( all in Smartsheet, of course ). The idea was that there are often many misc small tasks that dont have precise start/stop dates, categories or dependencies, and really don't belong on a project…
Gamification
Gamification is a powerful tool for motivating better performance, driving results, and generating a friendly competitive environment. How about a new concept where users can receive a score/achievement/badge based on their use of Smartsheet over a day/week/month. The score could be a combination of activities like…
Using iframe the header row of the GANT chart is not legible
Any ideas to solve the following issue? I created an iframe inside an internal collaboration tool (IBM Connections). The iframe works OK apart from the header row of the gant chart. In a browser window I see The text is there - but it is white on white.
How to calculate the Actual Duration only when the Actual Start and Actual Finish have values?
Hi, I'm working on a Smartsheet of which two of the columns are "Actual Start" and "Actual Finish". I have a third column called "Actual Duration (days)". Both the "Actual Start" and "Actual Finish" columns are date type columns and "Actual Duration (days)" is a Text/Number type column. What I want to have happen is as…
Google form → SmartSheet → E-mail Alert
I created a google form that is linked to a smartsheet. (I had to create a google form because smartsheet doesn't have a multicheck option available for the web form capability). I'd like to use the alerts capabilities of SmartSheet so when someone fills out the google form, the answers to go the smartsheet, and it will…
