We are membership based organization. We currently are implementing a new membership fee structure based on how old the member is:
<20= 250 €
20-25 = 500€
26-30 = 800€
31-34 = 1.200€
35 = 1.200€
(older and equal to) 40 = 500 €
I have all the memb...
We have a weird way of keeping track how many interviews our interviewers have done.
I would like to know how to count the number of times “1” comes up in each cell across all columns from Jan 2020 - August 2020. So in my simple way of formulating it...
I am running a membership organization, we have “Member Since” that is a year, e.g 2014, 2018, etc.
I want to calculate on a column to the right, how many years they have been member.
Something in simple words like =TODAYS YEAR - “Member Since” (in...
kuovonne:
YEAR(TODAY()) - VALUE({PGM (YEAR)} & "")
YEAR(TODAY()) - VALUE({PGM (YEAR)} & “”) worked!! :grinning_face_with_big_eyes:
Thank you so much!
The original was not a look up :slightly_smiling_face:
Hi @kuovonne,
Thank you for response, unfortunately there is places that it comes up twice.
I totally agree the rest of our data base is normalized, but unfortunately I am not allowed to adjust this one.
Is there any way of counting it if a “1” come...
ScottWorld:
YEAR(TODAY())-{PGM SINCE}
Thanks for your follow up! I think this is sufficient: https://airtable.com/shryQPChJB9SecTwW
It still does not work in here as well.
Unfortunately it does not work, it says error. :frowning: The column PGM Since, is a “number” not a “date” maybe that why?
We have the specific date, but not for all our members, since we just switched to a new more comprehensive data tracking syst...
