-
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…
-
Conditional Formatting
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?