This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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)
