SMP - profile

SMP · Jul 27, 2021

I have 2 different kinds of {App Pseud} formats, e.g. kay_obsessive goblin fic (Kiestan) Then I have a formula to spit out a URL, where the concatenate is the important bit: IF(OR({Work Submission Pseud}!={Synced Participant},{Assigned Writer(s)}=BLA...

SMP · Jul 24, 2021

So when I first built this IF statement, it brought back “Drabble” correctly when the Word Count was 100 words: IF({Word Count}=100,“Drabble”,IF({Word Count}=200,“Double Drabble”,IF({Word Count}>39999,“Novel”,IF(AND({Word Count}>17499,{Word Count}<40...

SMP · Jul 27, 2021

Yes! Thank you so much!

SMP · Jul 25, 2021

No. You can only lookup one thing at a time. Your goal here is to lookup the rate. Your table infrastructure and calculation fields determine where you’re going to get the rate from. Where you want to put the calculation fields is determined by how a...

SMP · Jul 25, 2021

If you have the rate stored on the table with the inputs, then you can do a straight lookup. If you’re looking up each of the two inputs, then add a third formula field where you divide and format the results as a percentage.

SMP · Jul 25, 2021

I just click on the linked record the lookup is from and it opens up to edit. Is this not working for you? I have also created reciprocal fields by running one or other target off of a formula, e.g. if I mark an item in the Gift Calculator table as A...

SMP · Jul 25, 2021

Ah! Thank you! I forgot the paragraph count had a rounding requirement to work. I’ll work on fixing it. ETA: Updated Word Count field to IF({Checked for Single-Word Paragraphs?}=BLANK(),BLANK(),ROUND({Space Within Paragraph Count}+{Paragraph Count},0...

User Statistics

User Activity

Unexpected duplicate character on the end of a formula result

Complex IF using the result of another formula field

Re: Unexpected duplicate character on the end of a formula result

Re: Newbie Help: Array Formula

Re: Newbie Help: Array Formula

Re: Reciprocal editing of Lookup fields

Re: Complex IF using the result of another formula field