I have a table that is doing some date calculations, but can't get one of them to work. I have a "latest activity" column, formatted as a number. I am trying to use date_add to count days until/since that number. I tested my formula:
So using that same logic but making the "30" a reference to that "Latest Activity" column, the formula for my last column is:
But this doesn't work. Can someone help me understand why this doesn't work?