This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...