Presenting N/A or Entering Date in Reports
We are attempting to come up with a formula that will present N/A in a Date column if the parent column lists N/A, otherwise we want the date functionality to work by presenting a calendar the user can select the date from on their individual report.
What we are running into when the report is created is that the formula is overtaking the "Date" function and not allowing the user to enter anything in their Date column.
The formula that the owner of the report created was:
=IF([7. Asset Mgmt-FM/PM Elect]@row = "N/A", "N/A", " ")
Could you please help us come up with a formula that will allow both to present in an individual report?