HiI would appreciate any assistance with my formula.The end goal is that my Cost field should automatically calculate a cost based on a combination of options selected from the Frequency, Activity, and Complex fields.The dropdown options for Frequenc...
Hi
We would really appreciate some assistance with one of our formula fields.
Background - also see screenshot:
In our first column, we have a date field called “Lifetime Last Payment”, which we manually complete.
In our second column, we have a form...
We have the following columns in our database:
Date Joined - regular date
Last renewed - regular date
Next Renewal - formula (IF({Last Renewed}=BLANK(),BLANK(), DATEADD({Last Renewed},12,“months”))
However, I also need to include my month-to-month me...
Hi all
I would really appreciate some support to come up with the correct formula for the columns in the screenshot below.
I want the price in the standard pricing column to auto-populate when a selection has been made in the payment options column.
...
What I need:
For a field to update automatically with a status change if there is 21 days remaining before the clients renewal date.
For example, if the next renewal date is 21 days away I would want a “Status of Renewal” field to say ‘Close To Renew...
Thanks Adam, it is working now.
I just had to change one last thing; so the formula now reads as:
IF(
{Lifetime Last Payment} = {Final Lifetime Instalment Date},
“ :white_check_mark: Paid in full”,
IF(
{Lifetime Next Payment} <=TODAY(),
“ :triangula...
Hi Scott,
I needed 3 options for the renewal status so the formula that I mentioned to Adam is working perfectly.
However, I need a formula that will calculate a 12 month and a 3 month ‘Next Renewal’ date.
(IF({Last Renewed}=BLANK(),BLANK(), DATEADD(...