I am creating a budget and have amounts incoming at various frequencies. I want to create a field that calculates the monthly amount based on a formula. This is the formula I have got but I get an Invalid Formula error message:IF({Frequency} = "Daily...
Thank you! I now have it like this but it's still giving me an the error "Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.": IF({Frequency} = "Daily", {Amount} * 30,IF({Frequency} = "Weekly", {Amount} * 4...
