Hi, I have two tables for which I'd like create a formulaTable 1Feature NameFeature End Date Table 2Sprint NumberSprint Start DateSprint End DateI'd like to create a formula that checks if "Feature End Date" is between "Sprint Start Date" and "Sprint...
I resolved that by using script + automationlet table1 = base.getTable("Table 1");
let table2 = base.getTable("Table 2");
let table1Records = await table1.selectRecordsAsync();
let table2Records = await table2.selectRecordsAsync();
for (let record ...
Thanks Mike! I followed the steps that you mentioned, however it looks like I had to associate the Sprint Number (Table 2) with Feature (Table 1) for that to work. Only when I created a column in Table 1 with "Sprint" and assigned it manually, "Check...
