Edit a Calculated Field and Change the Source Field
We have a daily production meeting to go over where our copy editors and visual artists are with their current projects. Right now, we have a report layout that is working very well for us, but it uses several calculated fields and right now we can't update records from the new layout.
We have a field "report status" that pulls data from a "status" field if we are still working on the project but then pulls data from a "vendor" field when the job goes into production.
Is there any way to keep the calculation in place, but be able to edit and have changes go back to the source field?
Or, is it possible to have a layout display a certain field based on a calculation, ie: If the job is in production, show the vendor in column 3, otherwise show the status?