This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
