Percent Columns in Correspondance with N/A tasks

edited 12/09/19 in Smartsheet Basics


I am trying to create a gantt chart for tradeshows that allows you to grey out certain tasks that are not relevant to that show. I have a conditional formatting set to grey out the task and the row if you type "N/A" into the percent column. I am not wanting to delete the task/row, but just make it irrelevant - if that makes any sense. However, the percent column messes with it when it is a child task, is there a way that I can set a formula to ignore N/A tasks/rows in the percent column?


Attached is a screenshot with what I am referencing. The percent complete column parent task shows 99% complete, when I am wanting it to show 100% because two of the children tasks are greyed out.


Please help