Calculators & Forms

Basics

• Create an app from an Excel calculation
• How to turn an Excel form into an app and collect data
• Do's and Don'ts for your Excel Spreadsheet
• Common error messages in Excel and Google Sheet and what they mean
• Change the order of elements or arrange them next to each other
• Add Cell | How to add cells subsequently

Advanced

• Show or Hide elements based on conditions
• Conditional formatting of the background color
• Creating an App with User-Specific Data Entry

Additional functions

• Change heights
• Change font sizes
• Change the content type of an element
• Change colors
• Valid input values for settings made in the editors
• Searchable drop-down list

FAQ

• What do time values, separators and decimal points depend on?
• Can I add cells from a different worksheet?
• How do I upload my spreadsheet?
• Can I use my LibreOffice / OpenOffice Calc spreadsheet?
• Incompatible formulas between Google Sheets and Microsoft Excel
• Does Open as App work with macros in Excel?