Calculated Fields based on task Status
When using the table view the collection of data in custom fields can be automatically totalled. In our use case we collect pricing for different suppliers and then choose who has won the tender. We would like the feature to mark the suppliers that we aren't using as cancelled and the total function wouldn't pick these up so we have a clear picture of the overall cost of a project.
The ability for the automatic calculation to be dependant on active tasks would be very helpful.
Clarifying questions
On the vendors you are not using, how are you marking them as losing the bid currently?
Do you need to retain the data of the pricing of the losing bid for the future or could it be zero'd out?