Formula Error

Hi

I have the following formula that should look at the number of projects in a programme RAG statuses and return back a Red if there is 1 or more project with a Red RAG, return a yellow if there is 1 or more projects with a yellow RAG, otherwise return "Green".

=IF(COUNTIFS({Project to Programme Summary | Project Status}, "Red", {Projects Intake Sheet | Programme}, [Programme Dropdown]1) > 0, "Red", IF(COUNTIFS({Project to Programme Summary | Project Status}, "Yellow", {Projects Intake Sheet | Programme}, [Programme Dropdown]1) > 0, "Yellow", "Green"))

I'm getting an incorrect argument error but, can't figure out why? The project to programme sheet reference looks at project RAG statuses of all projects in the programme and the Projects Intake Sheet matches the Programme Name to the Programme name in the Project to Programme Summary sheet.


Can anyone help?!

TIA

Cheryl

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!