The issue is with how the nested IF statements are structured in your formula.Here's a corrected version: IF(
{2026-01 Members} = BLANK(), "2026-01 Members",
IF({2025-12 Members} = BLANK(), "2025-12 Members",
IF({2025-11 Members} = BLANK...
SWITCH statements do not support expressions to match against.However, you can use nested IF statements to create the formula you need:IF(
{% GRADE} = BLANK(), BLANK(),
IF({% GRADE} >= 93, 'A',
IF({% GRADE} >= 80, 'B',
IF({% GRADE} >= 70, ...
The only thing I would change is to move the sortedRecords out the main loop, this only needs to be done 1 time and not for every record. This will make the script more efficient removing unnecessary work.config = input.config();
if (!config.tableNa...
This issue can likely be resolved with a combination of formulas, rollups, and possibly scripts or automations.Could you provide a sample table or a more detailed description of how you envision the task numbers? Understanding the specific format you...
