Hi all,I've ran this code and don't have an error message coming up but when I click ok the final part of the 'If' formula is deleted.I'd like it to run so that all parts of the if formula work (three options): IF({Always On/Miniseries} = "Always On"...
I'm putting the below formula but it keeps coming up with an error message - any ideas why when each part seems to work independently. IF({Always On/Miniseries} = "Always On" , {Total Budget (USD)}*((13-{Number (from Start Date)})/12) ), IF({Always ...
I am trying to create a payment due date based on adding days (either 15 or 30) depending on what kind of vendor type is selected. Both 'if' parts of the formula work if I place them in separate formula fields but I would like this to all come throug...
I don't think this will work - as above I need the second part to work differently from the first, i.e. if Mini Series is selected the second line to apply.
This is a huge help thank you!! And if I want the first option to be either "Independent Contractor" or "Company" what would the best syntax be here? Apologies for the probably stupid question.
