Hey there. I’d like to alphabetize one set of records in a table but would like to write a formula that would exclude the word “the” at the beginning when alphabetizing. (I rather not just format as Title, The.) Any possible way to do this, or no, be...
Hey there, trying to get an IF/THEN statement correct here.
It’s a donation database. Each donation is linked to a Donor Account and a Campaign. In my Donor Accounts tab, I’m using a lookup field to determine which Campaigns each donor has donated th...
I’m having trouble understanding why this isn’t working. Essentially what I’m trying to do is find out how many authors were published each calendar year and each fiscal year. There are multiple issues published each year and each fiscal year, and so...
Hey everyone. I’m using this formula to calculate how many days it took for a response.
DATETIME_DIFF({Response date},({Submission date}), ‘days’) & " days"
I’d like to add a part to the logic that says if {Response date} is blank, calculate days b...
Hey there. I’m using this formula for a column:
DATETIME_FORMAT({Date of Donation}, ‘M/D/YYYY’) & " — " & IF({Donor Account}, {Donor Account},{Company account})
It’s pulling some company account names that have commas in the title, generating unwan...
That’s great! Thank you! Then how would I take that rollup — ARRAYUNIQUE(ARRAYFLATTEN(values)) — and create another column in the same table that counts the # of names that appears in that rollup? (That’s my ultimate goal, here. To have a column that...
Okay amazing. Can I be a total newbie and ask WHERE to put this formula? I added it to the end of my formula and it says it’s invalid:
DATETIME_FORMAT({Date of Donation}, ‘M/D/YYYY’) & " — " & IF({Donor Account}, {Donor Account},{Company account}) S...
