Retable offers a range of advanced column types that can make your data operations even more effective. These advanced features can elevate your data management and provide greater flexibility and functionality in organizing and analyzing your information. ๐
In your Retable project, you can add advanced columns from the 'Add new column' menu, customizing each column's unique settings to suit your data needs.
Table of contents
- Formula column
- Reference another table column
- Lookup values column
- Rollup column
- Autonumber column
- URL column
- Unique identifier column
- Geolocation column
- Collaborator column
- Created time column
- Created by column
- Last modified time column
- Last modified by column
- Conclusion
Formula column ๐ข
The Formula column is a powerhouse for calculations, automating your numerical operations such as addition, subtraction, and more, directly within your data rows. When you are ready to write your formula, Retable shows you some examples immediately.
![retable formula column](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/66683493cb69890c7371b04d_formulac.png)
For more in-depth exploration, you can visit the formula spreadsheet Retable team has created for you!
Reference another table column ๐
You can link your data seamlessly across multiple tables with the Reference another table column, enriching your datasets with interconnected information. This column type allows you to link another table in your project, showing all your data in one place so you donโt have to search through multiple tables.
![Retable reference another table column](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/666835abaef8758da97178a9_refc.png)
By using the Reference Another Table column, you can ensure that your data remains up-to-date and fully synchronized, providing a comprehensive view of your information at a glance. This feature not only simplifies your workflow but also enhances the overall integrity and utility of your data across Retable.
Lookup values column ๐
The Lookup values column dynamically pulls related data from the referenced row of the table you selected as reference, ensuring your information is always up-to-date with real-time synchronization.
![lookup values column](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/666836aae634a7edbb49e812_lookup%20column.png)
The lookup column is designed to automatically fetch and display relevant data, maintaining accuracy and consistency across your datasets. By using the Lookup values column, you can effortlessly keep your data synchronized, reducing manual updates and potential errors. To create a lookup column, you must first create a reference column.
Rollup column ๐
You can aggregate and summarize your data effortlessly with the Rollup column, which allows for customized calculations across your records. Rollup column lets you perform a variety of calculations, such as sums, averages, counts, and more, all tailored to your specific needs.
![retable rollup column](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/6668385f95fa2aa84dabb845_rollup%20column.png)
Whether youโre tracking totals, computing averages, or generating other summary statistics, the Rollup column provides a powerful and flexible tool to enhance your data management and reporting capabilities. To create a rollup column, you must first create a reference column.
Autonumber column ๐ข
You can organize your records sequentially with the Autonumber column, offering an automatically incremented numbering system for unique identification.
![retable autonumber column](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/66683fb044fe907f1d8c33ca_autonumberc.png)
The Autonumber column simplifies the process of maintaining order and ensuring each record has a distinct identifier. The Autonumber column is perfect for scenarios where you need a reliable, incremental numbering system, such as tracking entries, managing inventory, or keeping logs.
URL column ๐
You can embed clickable links into your Retable spreadsheets with the URL column, enhancing your records with quick access to web resources. If the URLs look complicated in your table, you can always choose the option to show them as buttons, making it easier for your team to click and redirect.
![URL column](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/666841990c14d15c2a62e01b_URLC.png)
This not only keeps your table clean and organized but also improves the usability of your links, ensuring that everyone can quickly and easily access the necessary resources.
Unique identifier column ๐
You can generate distinctive and auto-generated codes for your records using the Unique identifier column, ensuring each entry is unmistakably identified. These codes can be applied to passwords, product codes, or user codes, ensuring their uniqueness and preventing manual changes. You can customize the format with upper and lowercase letters, length, and even add numbers or symbols.
![retable unique identifier column](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/666843b8d54599f705b2b78a_uuid%20column.png)
Retable's unique identifier column allows you to customize your unique identifier. You can use uppercase, lowercase, numbers and symbols and you can set the length of the identifiers.
Geolocation column ๐
Enrich your records with precise location data using the Geolocation column, incorporating mapping capabilities directly within your tables. This feature allows you to add exact geographic coordinates to your entries, providing valuable context and enhancing the informational depth of your data.
![retable geolocation column](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/666844890c228623efb96df3_geolocation%20column.png)
By integrating mapping functionality, you can visualize locations, track geographic trends, and improve spatial analysis, all within the convenience of your Retable spreadsheet. Whether youโre managing assets, tracking deliveries, or analyzing regional data, the Geolocation column adds a powerful layer of location-based insight to your records.
Collaborator column ๐ฅ
The Collaborator column brings team functionality into your records, allowing you to assign and notify collaborators directly within cells. You can add multiple collaborators and notify them when they are added or when the row gets updated and changed.
![retable collaborator column](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/66684746c3de94403826b407_collaborator%20column.png)
To assign tasks to your colleagues via the collaborator column, you must first add them to your project as collaborators.
Created time column ๐
Track the inception of your data entries with the Created time column, which automatically records when each record is added. You can format the date as you like and can also include time.
![retable created time column](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/6668482486a149d0a94db505_created%20time%20column.png)
You cannot manually change the data in the created time column. This is a metadata column and automatically gets its data from the date the related row was created.
Created by column ๐๐ป
Identify the creator of each record with the Created by column, offering clear accountability within your collaborative workspace.
![created by column](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/666848b3b5de7e5ea9e2b136_created%20by%20column.png)
You cannot manually change the data in the created by column. This is a metadata column and automatically gets its data from the the related row was created.
Last modified time column โฑ๏ธ
Stay informed on the latest updates to your records with the Last modified time column, marking the most recent changes. You can format the date as you like and can also include time.
![retablee last modified time column](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/6668498ae11e20ff278c1ea9_last%20modified%20time%20column.png)
You cannot manually change the data in the last modified time column. This is a metadata column and automatically gets its data from the time the related row was modified.
Last modified by column ๐
The Last modified by column reveals who last edited each record, providing transparency in your team's data modifications.
![last modified by column](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/66684a85864166f62abfd7a4_last%20modified%20by.png)
You cannot manually change the data in the last modified by column. This is a metadata column and automatically gets its data from the the related row was modified.
Conclusion
With Retableโs advanced column types, you're well-equipped to handle more complex data operations and automate processes for maximum efficiency. These features not only provide depth to your data but also bring a level of precision and interactivity that can transform how you manage information. Explore these advanced columns to enhance your data management and streamline your workflows. ๐
Elevate your Retable experience by starting for free today! Dive into the Retable Academy to discover a treasure trove of resources that will enrich and support your journey.
more
Related Resources
Create your smart data management solution
Plan, track, and analyse with your ease. Transform your data with an all-in-one platform, collaborate with your teammates.
Try for Free![Retable free no login online spreadsheet](https://cdn.prod.website-files.com/6295d1a43222795aaac32b12/641e09f082c9bb71ac2df0ce_Group%2026821.png)