Search the Community
Showing results for tags 'formulas'.
Hello all, I have a current Excel Spreadsheet and new to Caspio I am creating a formula in my data sheet, however the existing Excel one I copy over is not functioning. Let me explain here: The current Excel Formula is: =ROUND(((DAYS360(J7;$P$2))/360);1) where J7 is a date of birth, $P$2 is the current date (today) and the answer should read the person's age example 59,2. How would I convert this to Caspio? Regards, Mark (Johannesburg, South Africa)
I have raw data fields that contain many values that need to be extracted to their own columns on a table. In Excel, I was using a nested If(isnumber(search function to extract the various values to their respective columns. How do I do this in Caspio? The attached file shows a couple of examples of before and after. TIA! S. Help on Data Extraction.xls