Change dot color based on date field

Ruth Schoonover

I am trying to come up with a formula that will change a RYG symbol to green if the date in another column is within the first 14 days of a month.

The symbol column is already set up with the right column type.

Thank you for the help!

bisaacs

Hey @Ruth Schoonover,

I would do something like this in the RYG symbol column:

=IF(DAY(Date@row) <= 14, "Green")

Hope this helps!

bisaacs

Hey @Ruth Schoonover,

I would do something like this in the RYG symbol column:

=IF(DAY(Date@row) <= 14, "Green")

Hope this helps!

Ruth Schoonover

Thank you, that did the trick!