Valerie_Miles - profile

Valerie_Miles · Mar 07, 2022

I am trying to automate the calculation of an award based on an age category (“PVSA Age Group”) and a number of hours volunteered (“Total PVSA Hrs.”) (see chart). I think I need nested IF statements with an AND, but not sure. It’s not working so fa...

Valerie_Miles · Mar 08, 2022

This works! And is much more elegant than my 4 extra columns for the single solution. I was so close. Thank you for the foundational knowledge that I can apply to future formulas. Now let me know how to Venmo you a coffee. Thank you very much Moha...

Valerie_Miles · Mar 08, 2022

You are absolutely correct. I did not want to concatenate. Thank you. How to add (not an &!) the condition if the PVSA Age Group is “Young Adults” or “Adults”? The other formulas to be part of the decision are: for Young Adults: IF(AND({PVSA Age ...

Valerie_Miles · Apr 12, 2021

I also need to return the latest date (of many dates, and most are in the future.). Any reason why this doesn’t work? DATETIME_PARSE(MAX(INT(DATETIME_FORMAT({Ins CR}, ‘YYYYMMDD’)),INT(DATETIME_FORMAT({App CR}, ‘YYYYMMDD’))),INT(DATETIME_FORMAT({Loan ...

Valerie_Miles · Jun 28, 2019

What a great idea, thank you. My tables are for my eyes only, so adding the color pop and the emojis has brought a bout of whimsy to my desk time.

Valerie_Miles · Jun 28, 2019

Same question / problem. Even when I select “in a grid” or “in a list”, I still get one record on one page. No, “one per page” is not selected, but I am getting one per page. Aggravating really.

User Statistics

User Activity

Formula to return a result based on two variables (with ranges) in a chart

Re: Formula to return a result based on two variables (with ranges) in a chart

Re: Formula to return a result based on two variables (with ranges) in a chart

Re: How do I return the most recent of two dates?

Re: Color Code / Hide Tables?

Re: Multiple Records with Page designer block?