Formula to display cell content based on health status?

CJB

Hi - I want to be able to return the content of a cell (in the case of the lower image, the content in Level 0, "Project" column) if the health status is "red" in the "Overall Health" column to display on the project dashboard. Any help would be much appreciated!

Brett Wyrick

This is off the top of my head, but this is how I'd do this:

Create a report (File>New Report), add the filter to include all rows with an "Overall Health" column value of "Red". Then I'd add that report to the Dashboard. Would that work?

‎Let me know!

‎

Brett Wyrick

This is off the top of my head, but this is how I'd do this:

Create a report (File>New Report), add the filter to include all rows with an "Overall Health" column value of "Red". Then I'd add that report to the Dashboard. Would that work?

‎Let me know!

‎

Brett Wyrick

@CJB Does the solution I posted above work for you?

CJB

Sorry for the delay! That sounds actually super simple... thank you! Hoping this will do the trick!

Brett Wyrick

https://community.smartsheet.com/discussion/comment/310619#Comment_310619

Happy to help, let me know if it doesn't work or if you need further assistance!