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 · Jan 21, 2025

THANK YOU!! I just had the lookup filed inside the quotes. Learned something today that I can use across many other button fields.

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.

User Statistics

User Activity

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

Re: Button URL formula with cell value contained in the url

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?