I’m trying to use a math column to calculate a storage fee ($0.10 per day per item) allowing the user to input date and item count. The math column won’t allow me to format $ and forces duration due to using dates. Am I missing something?

the whole column needs to be in the same format

1 Like

So how do I turn (now - 30 days ago) into “30” instead of 720:00:00?

If i was in your situation i will use google sheet to convert date to be number then i will use the math. You might need to dublicate the currency column and use the dublicated column as number too. Try

Use either trunc or round in your math formula (this behaviour changed a few months ago)

3 Likes

Thank you!

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.