I am wondering if someone might be able to help me. I am trying to make a rooming list in Caspio and I am struggling a bit with Syntax of Caspio formulas. I need to put a "1" in each column where the check in date is less than or equal to that night's booking date and check out date is more than that night's booking date. My formula in Excel looks like this:
=IF((AND($D19<=J$1,$E19>J$1)),1,0)
Where D19 is check in date and J1 is the night in question and E19 is Check Out Date.
Is there a way to do this kind of calculation within caspio?
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
valentid
Hi All,
I am wondering if someone might be able to help me. I am trying to make a rooming list in Caspio and I am struggling a bit with Syntax of Caspio formulas. I need to put a "1" in each column where the check in date is less than or equal to that night's booking date and check out date is more than that night's booking date. My formula in Excel looks like this:
=IF((AND($D19<=J$1,$E19>J$1)),1,0)
Where D19 is check in date and J1 is the night in question and E19 is Check Out Date.
Is there a way to do this kind of calculation within caspio?
Thank you so much in advance if anyone can help!
Dawn
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.