Is it possible to have a cell updated with the balance of an account for a specific date? E.g., last date of each month

[rhowell]

@AutomationNation see my response in the new thread you created:

Fill Specific Cells with Account Balance

Hey @AutomationNation , Give this formula a try. It should return the end-of-month balances for each of your accounts for the last 12 months: =let( months_,12, query_, LAMBDA(data_, query_, headers_, QUERY({data_}, LAMBDA(query_text_, data_row1_, REDUCE(query_text_, FILTER(data_row1_, ISTEXT(data_row1_)), LAMBDA(query_text_result_, data_col_name_, REGEXREPLACE(query_text_result_, "`" & data_col_name_ & "`", "Col" & MATCH(data_col_name_, data_row1_, 0))))) …