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.

Upvote 0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
1 commento

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?

 

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Calculated Fields based on task Status
[this list is visible for admins and agents only]

Su
Didn’t find what you were looking for? Write new post