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. Archived 2016 Posts
Archives for June 2016
Discussion List
Print out of gantt chart is incomplete
Why is the printout of gantt chart is not printing completely. Seems a bit of words in gantt chart missed out.
Naming a Cell
Can Smartsheet let you "Name" a cell, like in Excel? This would be really useful. You could name certain milestones like "Launch Date" and then automatically calculate the dates of other tasks by subtracting/adding from that. For example, the due date for "Approve Launch Publicity" could be =LaunchDate-14 Today you have to…
How to automate Harvey Balls based on % Complete Summary Field
Hi everyone, I'm looking to find a way to automate the Harvey Balls symbols based on a % complete Summary field where the percente complete is 25% 50%, 75% or 100%. Any help is greatly appreciated. Thanks, Robert
Adding the sum of a range of cells using the IF function
Hi! I wonder if someone can help me. I have a range of cells using the IF function. I'd like to calculate that range using the SUM function in another cell, but it just comes back with the total as "0". Is there a special formula that I need to use to complete this action? Thank you
Formulas
Thanks for the help!
Trying to change RYG based on status of a group of rows and Subtasks
so i have rows that turn red green or yellow based on progress i would like a master progress since the rows are normmaly collaped that shows over all status of a section i have code but its not working =IF(COUNTIF(Status18:Status25) = 0, "Red", IF(COUNTIF(Status18:Status25) = 100, "Green" , IF(COUNTIF(Status18:Status25) <…
Here we go!! Ready to roll out our BETA project plan!
After a couple of weeks learning Smartsheets and simplifying our project plan, we are ready to beta test our PM Lite template. https://app.smartsheet.com/b/publish?EQBCT=f5644ec0fe854b2b9c3bf74084bf86d7 It's still pretty rough but with a group not use to a formal PM process it should get us started on the right track.…
Feature Request - Ability to lock discussion & attachment columns
The ability to lock the attachment and discussion columns would allow for us to use sheets for document control over a period of time. It would be good to add this ability without locking the entire sheet to the user. Example, I want to have a drawing review sheet - and I want to have a drawing on each row that will evolve…
Automated Notifications for Swim Lane Changes in Card View
Now that Card View has been unveiled (and I love what I see so far), is there any way to automate notifications based on status changes? For example, let's say that we are using card view for a Kanban board, with swim lanes for "Work Queue," "In Development," "In Test," and "In Production." There are different people who…
Learn more about Card View in our Free Webinar!
Excited about Card View? Join us next Wednesday at 10am PT and 4pm PT for a live webinar to learn more about card view and how you can use it. Register for the webinar here.
