Formula for a checkbox with a date requirement

Hi there,

I’m new to this, so i will try to make it more clear as possible.

Imagine i have a service with an expire date on 15/04/2024, since there are less than 6 months left to expire, i want a checkbox to display the value “true”

So, always when i have a service with less than 6 months to expire the checkbox turns “true” automatically.

G column is the service expire date (dd/mm/yyyy)
I column is the checkbox that i want to make “true” when it meets the requirement it needs


Can you help me with that?

Thank you for any help in advance.


Please refer to the steps below.

  1. Go to the form page.
  2. Let’s say the “FIDELIZACAO” field is on cell A5. In another field (on A6 for example), you need to find a formula that calculates the days between today and the date value on the “FIDELIZACAO” field. The field’s formula should be A5-TODAYTZ()
  3. Create another field and apply conditional formulas to check if the value on A6 is less than 180 days (6 months), and return “true” if the conditions match. The formula should be: IF(A6<180, “true”, “false”)
  4. Apply the daily recalculation workflow to recalculate your formulas daily.
1 Like