Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
I have a project sheet that has the tasks, actions, risks, etc. The risks have specific columns that apply to it. I want to hide these columns unless the item type is risk.
I have searched for help with this but can't seem to find the solution.
you can't hide columns conditionally or using a formula. The best you could do is create a report for only risk items and include those columns, or use conditional formatting to black out the non-applicable cells if the type = 'risk.'
As an aside, how would you hide a column for one type, but not another, assuming both types would be present in different rows? If you hide a column, the whole column disappears, not just certain cells.
I did create a report for risks but users are complaining they don't want to see the risk related columns.
These columns are specific to risks and not shared. I had to put everything on one sheet because upper management wants to see everything on one sheet per project without using reports.
