Formula to display cell content based on health status?

Options

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!




Best Answer

  • Brett Wyrick
    Brett Wyrick ✭✭✭✭
    Answer ✓
    Options

    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!

    If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.

    Love,

    Brett Wyrick | Connect with me on LinkedIn.

    ------------------------------------------------------------------------------

    2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!

Answers

  • Brett Wyrick
    Brett Wyrick ✭✭✭✭
    Answer ✓
    Options

    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!

    If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.

    Love,

    Brett Wyrick | Connect with me on LinkedIn.

    ------------------------------------------------------------------------------

    2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!

  • Brett Wyrick
    Brett Wyrick ✭✭✭✭
    Options

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

    If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.

    Love,

    Brett Wyrick | Connect with me on LinkedIn.

    ------------------------------------------------------------------------------

    2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!

  • CJB
    CJB ✭✭
    Options

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

  • Brett Wyrick
    Brett Wyrick ✭✭✭✭
    Options

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

    If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.

    Love,

    Brett Wyrick | Connect with me on LinkedIn.

    ------------------------------------------------------------------------------

    2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!