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!

AllisonM

Having a problem with the following code. I am trying to count only the Project ID rows while determining if the Projects are green. I will be trying this for my milestone column as well. Any assistance is appreciated.

=IF(AND(COUNTIFS([Project ID]:[Project ID], "<>""") > 0, DAY([Due Date]@row) <= 30), "Green", "")))

Andrée Starå

https://community.smartsheet.com/discussion/comment/442125#Comment_442125

Hi,

I hope you're well and safe!

Can you share some screenshots? (Please delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

AllisonM

I tried this formula as well but did not work:

=IF(COUNTIF({Project ID}:{Project ID}, "<>""", IF({Status}@row = "Complete", "Blue", IF({Legislative Due Date}@row <=TODAY(7), "Red", IF({Legislative Due Date}@row =TODAY(15), "Green", "Yellow")))))

Again, thank you for the assistance.