Bill by usage

Ask for Help
1

Does anyone have a creative way to bill by usage similar to the way Glide charges for their Private Pro App “$2 dollars per user, per month, billed monthly”

In my situation I am using a spreadsheet formula, the basis of which is =COUNTIFS(C:C;"=My_Item";A:A;">="&TODAY()-30) to determine usage of a particular item over the last 30 days.

This is working as expected however it could be more precise (is just the last 30 days) and I only need the result on the 1st of the month…not updated everyday.

I know this would be possible with app script but was wondering if there is an elegant way to do this in sheets and or glide. :grinning:

2

Is there any disadvantage of having it updated everyday?

3

I’d like to bill once a month (for the prior month) while giving the user the first few days of a new month to complete payment.

I think I’m on the right path with the following formula where column A contains your dates.

=COUNTIFS(A:A,">="&EOMONTH(TODAY(),-2)+1,A:A,"<="&EOMONTH(TODAY(),-1)

A count of all the dates from the prior month…

Update: Adding some additional criteria to the syntax achieves my desired result.

1 Like