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.
Automating RYG balls based on several columns
I am trying to automate the RYG ball status column, based on several factors.
- if not marked 100% complete in the [% Complete] column after the [End Date] or;
- if less than 7 days before [Start Date] and [RS] and [WOA] are not both =1
- If greater than 7 days before [Start Date], [RS] and [WOA] are not both =1
- If today is before [End Date] and [RS] and [WOA] are both =1
- If [% Complete] = 100%
[% Complete] is formatted for %
[Start Date} and [End Date] are of course, formatted as dates.
[RS] and [WOA] are both check boxes.
I end up getting turned around in nested IF statements and am ready to pull my hair out...