Formula for RYG based on % complete
Trying to get RYG symbols for % completed on tasks. I am getting #UNPARSEABLE =IF([% Complete]4 = "100%", "Green", IF([% Complete]4 = "50%", "Yellow", IF([% Completed]4 = "0%", "Red", " "))) Can anyone please help?
Option to Open to Today's Date not saving
Hello, Not sure if anyone else has seen this but when I select the Timeline Display option to Open to Today's Date, the option doesn't save. I need to select the option each time I open the sheet. Seems like a bug or I'm missing something. Thanks
Alerts & Actions - Update Request
With the new feature to send update requests automatically (Awesome feature by the way), I've noticed a few draw backs to this option: * the request no longer grabs the primary column information but the sheet name. This makes the request pretty generic to the recipient instead of specific to that row * There is no ability…
Unable to access specific sheets
Hello, Has anyone lost access to a sheet due to a generic Ajax error and had it successfully fixed? We have a Enterprise account with hundreds of users, yet none of us are receiving timely communication or any resolution plan from Smartsheet support. Have any of you run into this before? I am very concerned we are going to…
Community Suggestion: Submit Product Enhancement Requests
Every once in a while, I get an idea and wonder why I did not think of it before. When you see a post on the Community that asks for a feature, enhancement, or bug fix you want, click on that "Submit Product Enhancement Request" link to the right. Capture the link for the post you are referencing and say "See this post"…
Highlight work starting on a weekend
I was planning to use =IF(OR(WEEKDAY([Start]1) = 1, WEEKDAY([Start]1) = 7), "Weekend", "Weekday") to highlight work starting on a weekend.Where 1 is Sunday and 7 is Saturday. And then use Cond Format as suggested by Greg Gates. Says "Unparseable" My Start is Date job starts column and Weekday is column indicating weekday…
Hello, Is it possible to apply conditional formatting only in specified rows or does it only apply to the whole sheet? My example is as follows: I am currently tracking production on 20 units. For the first 5 units I do not care if the duration of a planned task exceeds its target. However for the next 15 units, I do want…
checking off multiple boxes in a column
Hi All, I have a column using checkboxes. I'd like to filter my rows (say by name) and after completing an action (email globally to the selected individuals) check off all boxs in that column.
Alerts for only incomplete tasks
I routinely send auto alerts 3 days before a task is due to serve as a reminder. I recently began sending another alert on the date that a task is due. However, I don't want to send the alert if the task is 100% complete. I guess that I was assuming that the alert wouldn't be sent if the task is complete. Is here a way to…
Sight View by Log In
I have a Sight that I built for a customer to view and interact. Is there a way to set there view by Log In. I.E. customer logs in and they see the projects and data they are assigned to. I have been told that this is not supported. Anyone have any ideas?