Hello
I am having problems finding the documentation for the following:
I have several “status” columns: Scope, Timeline, Financial Forecast and Resources.
They have the status attributes “On Track {Green}, Potential Risk (Yellow) and Risks/Roadblocks (Red)”
If any of these columns have the attribute “Potential Risk”, I need the formula column to read “Potential Risk” and be yellow.
If any of these columns have the attribute “Risks/Roadblocks”, I need the formula column to read “Risks/Roadblocks” and be red.
If ALL of the items are “On Track”, I need this formula column to read “On Track” (Green).
Most of the documentation I have found is for calculated fields with numbers/statuses combined. I just need to understand the logic a little more. Can you please help me out? thank you!
This should do the trick:
IF(SEARCH("Risks/Roadblocks",
{Scope}&{Timeline}&{Financial Forecast}&{Resources}) > 0,
"🟥🟥Risks/Roadblocks🟥🟥",
IF(SEARCH("Potential Risk",
{Scope}&{Timeline}&{Financial Forecast}&{Resources}) > 0,
"🟨🟨Potential Risk🟨🟨", "🟩🟩On Track🟩🟩"))
Jim - The Monday Man (YouTube Channel)
What is Make & How can it help you with monday?
We Create Custom Solutions - Your Make or Ours
Schedule a 1-on-1 Tutorial Session (for monday, Make or Google Sheets)
1 Like
Thank you so much. This works well! This was more complicated than I expected. I really appreciate it.
1 Like
You’re welcome! I’m glad it works for you!
Jim - The Monday Man
Column Magic 
- the magical columns toolbox
What is Make & How can it help you with monday?
1 Like