Cell Formatting


Hi Community Gurus,

I need to create a Grid Report in Smartsheet based on a task list. Each cell in the Grid Report contains a formula that retrieves values from the task list, specifically from the Status field. The requirement is to change the cell color based on the value fetched from the task list.

I tried using condition formatting but it is not considering the value coming from the formula.

Any support here is great help. Thank you in Advance.