ContributionsMost RecentMost LikesSolutionsFormula Duration in a nested if statementI have a formula that calculates the duration if the checkbox is checked. If([Appraisal Received]=true, (ToDays(([Appraisal Due Date]-[Appraisal Received Date])))) I am trying to run a nested ifstatement that will output " ON TIME" is the result is <=0, or display the calculated duration past the due date in a red background with white letters. Thank you, Re: Automatic website import to QB fieldDan: Would the "stuff" action be via a formula field? I get an error when i run the code. I am new to writing the API call function for edit record getting data from an outside source into the form..Thank you,