New to Klipfolio... having issues with date functions, I think? Although, I'm having a hard time even getting examples from the docs to work.
Ultimately, I want to sum a column (Planned_Hours) if a date column (First_of_Month) equals this month.
I tried this formula:
But there is no output:
In trying to troubleshoot, I tried a couple of seemingly simple things: "abc", 42, and TODAY() - none of them worked:
What am I doing wrong???