# Re: Using formula to auto populate a next check date field based of single selection and last check

189 0
cancel
Showing results for
Did you mean:
4 - Data Explorer

Hello,

Struggling to work out where I'm going wrong. I'm trying to use a formula to auto update the "next check date" of equipment based on the date it was last checked and a single selection box.

Eg. Harness checked 1/1/24

Check frequency Monthly

Next check date 1/2/24

My current formula is as follows:

IF(

{Check Frequency} = "Annualy",

{Check date}, 1, "year"

),

IF(

{Check Frequency} = "6Monthly",

{Check date}, 6, "months"

),

IF(

{Check Frequency} = "Quareterly",

{Check date}, 3, "months"

),

IF(

{Check Frequency} = "BiMonthly",

{Check date}, 2, "months"

),

IF(

{Check Frequency} = "Monthly",

{Check date}, 1, "month",

),

IF(

{Check Frequency} = "BiWeekly",

{Check date}, 2, "weeks"

),

IF(

{Check Frequency} = "Weekly",

{Check date}, 1, "week"

)

)

)

)

)

)

)

)

)

18 - Pluto

Hmm, I think you had an extra comma in there.  Try this:

``````IF(
{Check Frequency} = "Annualy",
{Check Date}, 1, "year"
),
IF(
{Check Frequency} = "6Monthly",
{Check Date}, 6, "months"
),
IF(
{Check Frequency} = "Quareterly",
{Check Date}, 3, "months"
),
IF(
{Check Frequency} = "BiMonthly",
{Check Date}, 2, "months"
),
IF(
{Check Frequency} = "Monthly",
{Check Date}, 1, "month"
),
IF(
{Check Frequency} = "BiWeekly",
{Check Date}, 2, "weeks"
),
IF(
{Check Frequency} = "Weekly",