I’m building a time tracking and project reporting base, and I often find myself needing to use conditional rollups to create meaningful reports. This means I need to create a ton of IF formula fields on one table to rollup on another table.
It would save substantial amount of time if Airtable had a bulk formula field creation feature. This could be an option in the field dropdown menu:
Selecting this option would allow users to upload a .csv file containing each forumla:
IF({Person} = "Anne", {Hours}, 0);
IF({Person} = "Clyde", {Hours}, 0);
IF({Person} = "Daisy", {Hours}, 0);
IF({Person} = "Elle", {Hours}, 0);
IF({Person} = "Gordon", {Hours}, 0);
IF({Person} = "Hilda", {Hours}, 0);
IF({Person} = "Ken", {Hours}, 0);
IF({Person} = "Julia", {Hours}, 0);
...
And a formula field would be created for each value.
This would save countless hours and make Airtable even easier to use.
... View more