Guys,
I'm new to Smartsuite, though i used notion for long, so I was trying to do a basic formula for an app that tells me when i have to pay my subscriptions, based on the start date and the frequency (two different fields in the same app. I have put the below 👍
So if theperiodicity field is "monthly" yearly etc, than i check the diff between today and the start of the subscription and add it in the respective format. The problem is for example a subscription srated on Feb 2 2021 (a year subscription) should give me the next date Feb 2 2023 (assuming today is feb 1st 2023), but is showing me feb 2 2024. If i remove the +1 i have after the datediff than all the results will be wrong.
Can you help me ? Im going crazy with this so simply thing ....arrrgghhh....
IF( [Periodicity] == "Monthly", DATEADD( [Subscription Start], DATEDIFF( [Subscription Start], NOW(), "months")+ 1, "months" ), IF( [Periodicity] == "Yearly", DATEADD( [Subscription Start], DATEDIFF( [Subscription Start], NOW(), "years")+ 1, "years"), IF( [Periodicity] == "Quarterly", DATEADD( [Subscription Start], DATEDIFF( [Subscription Start], NOW(), "months")+ 2, "months"), IF( [Periodicity] == "One Time", [Subscription Start], NOW() ) ) ) )