Hi everyone. I’ve been banging my head against this for a while now and decided to ask the community.
In Google Sheets I had a spreadsheet with 2 sheets. One was holding expenditures and with dates, and a formula was used to derive a month and year o...
That would be great. I’ve just realised that it doesn’t remember the blocks per table. In my database I have different block for invoices page (invoice preview) and profit table (monthly profit chart). It would be great if I can link specific blocks/...
Elias
I had shelved AirTable for a few months because I couldn’t get it working and then life got busy. Just came back to this, and you’re right. I can just do this as a new view with grouping. No need to create a new table with that data as it’s alr...
Not sure if or how this would work.
In my example:
Column 1 has date of purchase
Column 4 has the amount
Column 5 has a derived M/YYYY value to allocate to the correct month
Table 2 has Column 1 with all M/YYYY values I’m recording details for. Colum...
Andy_Lin1:
RIGHT(“000”&{Revision Level},3)
Thanks Andy. That’s a great solution :slightly_smiling_face:
Works in my slightly overcomplicated Client ID formula:
UPPER(LEFT(SUBSTITUTE({Customer Name}, " ", “”),4)) & RIGHT(“000”&{ID},3)
