Bring back result based on condition
Hoping I can get some help with a formula. I have a date column that I want to bring back a "health result" depending on the 'finish' date. For example if the finish date is past today's date then it would be red and there would be different thresholds for each date range. Is this possible? The "health result" is a column that shows color coded red, yellow, green or blue dot"
Help Article Resources
Check out the Formula Handbook template!