Automuated Hiding and Unhiding of Columns based on certain conditions

[Anthony2]

Hi,

Please refer to the attached doc. I have a data table that I am attempting to automate. When someone fills in the description field, the next field "new/existing project" will automatically be populate.

If it is a new project, then I want column I to appear. Once column I is populated, I want it to dissapear.

If is an existing project then I want to hide column I.

The hiding and unhiding of the column (depending on whether it is an exsting project or new project) must be based on the row that the user is editing i.e. if the user decides to add the new line item to the table i.e. in row 14, then the conditional hiding/unhiding must be based on row 14's value of existing/new proejct.

Thanks,
Anthony