Hello! I am trying to write a formula for tracking what month something was checked as billed. I want to be able to group by month billed to show income by month. Currently I use this Formula for date billed when checked.
IF(Billed=1,TODAY())
This sh...
The idea i’m going for is simplicity in use. So for some it would be less effort to simply check a box rather than open a calendar the select a date. But the checkbox is also linked to a couple other fields so I figured why not string it into the dat...
This Formula seems to be working to mark the month billed by pulling it from the date billed field. But when the month changes will it change or is it static to the date billed field and remain correct to the month?
DATETIME_FORMAT({Date billed},‘MMM...
