Tracking Days of the Week Using a Symbol Column

anuelle

Hello,

Trying to see if there is a way to incorporate the progress bar option in the symbol column to track days of the week. Ex: If today is Monday, the bar would be empty, but if it was Wednesday, the bar would show as half full and Friday the bar would be full. Is there a formula that can accomplish this?

Christian G.

Weekday(date) return a value from 1 to 7 where 1 is sunday and 7 is saturday.

=IF(WEEKDAY(TODAY()) = 2, "'Empty", IF(WEEKDAY(TODAY()) = 3, "Quarter", IF(WEEKDAY(TODAY()) = 4, "'half", IF(WEEKDAY(TODAY()) = 5, "Three Quarter", IF(WEEKDAY(TODAY()) = 6, "FULL", "Empty")))))

This keeps the progress bar empty when it is saturday, sunday or monday

Christian G.

=IF(WEEKDAY(TODAY()) = 2, "'Empty", IF(WEEKDAY(TODAY()) = 3, "Quarter", IF(WEEKDAY(TODAY()) = 4, "Half", IF(WEEKDAY(TODAY()) = 5, "Three Quarter", IF(WEEKDAY(TODAY()) = 6, "FULL", "Empty")))))

Weekday(date) return a number from 1 to 7 where 1 is sunday.

this formula keep the progress bar empty on saturday sunday and monday

anuelle

If I wanted to have the formula to be based off a "start date" column, would that be possible?