Forum Discussion
Hi - I still need help if anyone has the answer.
Here's a better screenshot.
The funding years are 2025, and 2026. I need a formula that reads "First year ask is Yes, return 2025 from the field [First Year], if "Second year ask is Yes, return 2026 from the [Second Year] field.
My Numberic formula is only returning 2025, and my Text formula is returning all 5 years.
Numeric Formula:
var bool yone= [First Year Ask]=true;
var bool ytwo= [First Year Ask]=true;
var bool ythree= [First Year Ask]=true;
var bool yfour= [First Year Ask]=true;
var bool yfive= [First Year Ask]=true;
If($yone,[Year 1],
$ytwo,[Year 2],
$ythree,[Year 3],
$yfour,[Year 4],
$yfive,[Year 5])
My Text formula:
var bool yone= [First Year Ask]=true;
var bool ytwo= [First Year Ask]=true;
var bool ythree= [First Year Ask]=true;
var bool yfour= [First Year Ask]=true;
var bool yfive= [First Year Ask]=true;
List(",",ToText([Year 1]),ToText([Year 2]),ToText([Year 3]),ToText([Year 4]),ToText([Year 5]))
The only reason i have two is because I'm trying to figure out which is the right way.
Thanks!
Renee