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
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
Engineer's timesheet
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?
nested forumlas
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?
Resource Allocation
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?