Skip to main content

Looking for a dedicated Gross monthly income/loss Tab

  • April 27, 2021
  • 5 replies
  • 49 views

Looking to gather my monthly income(Sold inventory) and subtract it from all monthly expenses(utilities, property lease, office supplies, warehouse supplies, advertising, etc…) How can I create a formula or automation in order for this gross monthly income tab to work? Thanks

5 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • April 27, 2021

Instead of all those tabs, I would put all your records in one table and categorize them by a single-select field called “Category”. Then you can create different views for your different categories, and you can summarize with the summary bar.


  • Author
  • New Participant
  • April 27, 2021

Instead of all those tabs, I would put all your records in one table and categorize them by a single-select field called “Category”. Then you can create different views for your different categories, and you can summarize with the summary bar.


That sounds interesting. Would you be able to show me a few steps starting it? Also, how would I be able to track it monthly? I would like a monthly running tally. Thanks


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • April 27, 2021

That sounds interesting. Would you be able to show me a few steps starting it? Also, how would I be able to track it monthly? I would like a monthly running tally. Thanks


I’ve created a free training course on Learning Airtable here:


  • Author
  • New Participant
  • April 27, 2021

Thanks, I was able to figure it out. Its perfect


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • April 27, 2021

Thanks, I was able to figure it out. Its perfect


Looks beautiful! Congratulations! :slightly_smiling_face: