Hi
Is it possible (and if not could it be?) to edit the value in a cell of a column that does not appear on the original sheet where a line in a report is pulled from? In other words, I'd like to emulate a 'relational' database.
The use case is that we'd like to log results, measured using a series of indicators, of activities. So I'm looking for a way of logging multiple results against one activity line, in a separate sheet that is not the project sheet.