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.
Change Flag Color if Due Date is Greater than today
Hello everyone Very new in smarsheet and I have this problem I have basically a due date column and would want another column (flag field or RYG) to turn red once the due date is > today's date.
I have been getting #UNPARSEABLE errors everytime
=IF(AND([End Date]2 <= TODAY(), [End Date]2 >= TODAY(), RED)