Unlike the SUBTOTAL function, the SUM function is one of the most popular functions in spreadsheet workflow. This popularity is because we often add values in our dataset. However, it falls short in some situations because there is a more efficient way to do things. That’s where SUBTOTAL comes in. In this article, we will look at different situations… Continue reading SUM vs. SUBTOTAL Functions
Category: Tutorials
How Dates and Times Work
When doing any data processing work, it’s almost inevitable that you will at some point encounter a dataset that contains dates, times, or both. Most spreadsheet programs behave similarly as far as dates & times are concerned, but what of Spreadsheet.com? Do you need to be aware of any nuances? Well, let’s find out! You… Continue reading How Dates and Times Work
Use Forms to Collect User Data
If you collect data from multiple people but don’t want them to access to your spreadsheet, you can use the Form view in spreadsheet.com. As a result, the recipient of your form will not see the spreadsheet that stores their responses. You will not need to use a separate app; it is simply another view… Continue reading Use Forms to Collect User Data
How to Use the Primary Column
Every spreadsheet created in spreadsheet.com has a primary column. Even though it always exists, using this column is optional. For instance, if you are working on a single worksheet and keeping that worksheet in the sheet view, you may not need it. However, it can be vital if you take advantage of the kanban view,… Continue reading How to Use the Primary Column
Dropdown Lists in your Spreadsheet
Spreadsheet creators may want to use a dropdown list to limit the choice of values in a spreadsheet cell. You could do this to reduce typos or help the user narrow down their options. Historically, you had to do this through a cumbersome process called data validation. Data validation is when the spreadsheet creator applies… Continue reading Dropdown Lists in your Spreadsheet