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.
Same comment on multiple conversations
Hi Community, I was wondering if anybody knows a good way to quickly add the same comment to multiple rows. This will be a note to describe the circumstances for the setup of a group of projects on our project register. Any ideas appreciated. Chris
Has anyone created a timesheet for tracking/recording billable hours towards specific projects.
Conditional Formatting not working as per the rule set
Hi I have tried to set a basic rule and wanted to see if conditional formatting really works; however it is not working. Can you let me know if u are facing/have faced the same issue before?
Hello, I'm having trouble with my nested formula and activating the Red, Green, Gray, Yellow ball based on the % compelte column. =IF([% Complete] = IS BLANK, activate the RED ball =IF([% Complete] = less than 100%, activate the YELLOW ball =IF([% Complete] = 100% activate the GREEN ball =IF([% Complete] = 0% activate the…
Sorting Filter Names
Hi there! I have made multiple filters on my sheet and would like to sort them alphabetically. Is there a way to sort them in the drop down menu? Or would I have to re-create the filters and ensure I create them in that order? Thanks! Chad
Post Trial Review of Smartsheet as an IT Project Management solution
I've been assessing Smartsheet as a viable replacement for MS Project at our office over the last 30 days and I thought I'd share my finding with the Smartsheet community in case somebody else is also doing such a review. I'd also invite Smartsheet to respond to my observations if they feel I've misrepresented anything…
Multiple options in a dropdown list
I am creating a web form and I've created a dropdown list. I want the end user to be able to choose multiple options if needed, but the dropdown list won't allow that. How can I make that work? Or what is the other suggested format?
I don't know if I actually have an issue with the Allocation or if I just don't understand how it's supposed to work. I have a project list that has children. Each project has the same children (Planning, Design Acquisition, Design, Construction Acquisition, and Construction). The entire project and all phases of the…
Help! classify by date
Good night how can I sort the rows of a date column from my spreadsheet? I am using filters so I can't use the "classify rows" function. Is there any formula for columns to always be sorted by date order? thank you!
Assigning a number with a formula
I am creating a PO System. When I enter the name of who is making the request I want to assign a number to this person. This is what I have so far. =IF(Request1 = "Greg", 1) When i try to add to that I get #UNPARSEABLE =IF(Request1 = "Greg", 1), IF(Request1 = "Bill", 2) what am i doing wrong?