Next payment date

[MEC]

Hi,

I have the below spreadsheet formula

=WORKDAY(sum(IFS(N29=“Daily”,IF(WEEKDAY(Q29,2)=5,Q29+3,Q29+1),N29=“Weekly”,Q29+7,N29=“Trimonthly”,Q29+10,N29=“Bimonthly”,Q29+14,N29=“Monthly”,IFERROR(IF(EDATE(Q29,1)=index(Holidays!B:B,match(EDATE(Q29,1),Holidays!B:B,0)),EDATE(Q29,1)+1,EDATE(Q29,1)),EDATE(Q29,1))),-1),1,filter(Holidays!$B$2:$B1028,Holidays!$B$2:$B1028<>""))

Basically, what it does is, it returns the starting payment date of a loan based on the loan’s payment interval. The below is an example.

My problem is, i have to drag down the formula manually coz appsheet returns an error like the last row in the photo. Any help would be appreciated!

Thanks.

[LeventK]

May I humbly ask why do you need the Spreadsheet formula? Why don’t you perform the same with the AppFormula directly in the app?

[MEC]

To be honest, I’m still in the process of learning the appsheet formulas and don’t know how to directly transform it to an Appsheet formula. Any help would be appreciated.

[LeventK]

Need to know your spreadsheet and table structure so that we can understand which column values you are reading with that formula and what’s the dependency. Then we can propose something.

[MEC]

Hi @LeventK. I have managed to do it. Thank you.

[LeventK]

You’re welcome