Robert_Kolodzie - profile

Robert_Kolodzie · Aug 21, 2018

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...

Robert_Kolodzie · Apr 04, 2019

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/...

Robert_Kolodzie · Apr 04, 2019

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...

Robert_Kolodzie · Sep 23, 2018

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...

Robert_Kolodzie · May 23, 2018

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)

User Statistics

User Activity

Replicating Excel's and Google Sheets' SUMIF in AirTable

Re: Block(s) specific to the table/view you are on

Re: Replicating Excel's and Google Sheets' SUMIF in AirTable

Re: Replicating Excel's and Google Sheets' SUMIF in AirTable

Re: Adding Zero to number while maintaing same amount of digits