Press the F4 key to toggle between relative and absolute references in ranges in your Google Sheets formulas. It’s WAY quicker than clicking and typing in the dollar ($) signs to change a reference into an absolute reference

Read More

Link to generate responsive html for Caspio table headings – see 1c in code below. https://docs.google.com/spreadsheets/d/1ALj2K1ji7NV8xLrIQ3T4c5bNKKTu9XZ5J36a78Jjdqs/edit?usp=sharing

Read More

 [@field:First_Name]+Space(1)+[@field:Last_Name] not sure how to join a date field to a text field yet… (eg. Jane Smith, 12/12/2019)

Read More