Manual entry for Formula field.

Topic Labels: Base design
222 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a payment tracking table. It has fields that are Original Cost, Variable Cost, and Fields for each month(Jan - Dec): Formula Field). The original cost is linked from another table. If the user does not provide any value to Variable cost, The original cost value will be split into 12 months in respective fields for each month. Otherwise Variable cost value will be split for each month. 
But my requirement is User can add the cost for each month manually if the client has paid a different amount for each month So that we can calculate the balance amount for the rest of the month.

1 Reply 1

I'm afraid that's not possible.  A possible workaround would be to create one currency field per month and then update the formula fields you have for each month to use the manually input currency value if it exists, and if it doesn't to fallback to the logic you mentioned