Hey, I am sure it has a simple solution which I couldn’t find. I used grist a year ago I kind of forget how things work.
I have two table. One is original Month Name table and another with email campaign data. I referenced email campaign send month with the month Table. Now In the month table I want to get email campaigns revenue sum that matched the month. I used this formula =sum(Email_Campaigns_2025.lookupRecords(Month=$Month_Name))
It didn’t work. Can anyone help me with this?
I think you need to specify which column you want to sum.
Sorry typing mistake. the sum didn’t work, then I tried the without the sum but =(Email_Campaigns_2025.lookupRecords(Month=$Month_Name)) this also didn’t bring the result.
=sum(Email_Campaigns_2025.lookupRecords(Month=$Month_Name).NAME_OF_YOUR_NUMERIC_COLUMN_TO_SUM)
In the Month table this formula gives no value, so the sum also gives only 0. But I have data with sam e month name used as reference
$Month in your Email_Campaigns_2025 Table is a reference.
Can you try :
=sum(Email_Campaigns_2025.lookupRecords(Month=$Id).NAME_OF_YOUR_NUMERIC_COLUMN_TO_SUM)
