Is there a way to write a formula that will raise a flag to if row data for household size AND ...

Options
Overachievers Alumni

I am trying to write a formula that will raise a flag if the row data fits specific criteria for determining income eligibility for a project. Basically it would be if the data on that row in the household size equals a number and if the annual gross income is less than or equal to a dollar amount, we need it to raise the flag. This would also need to be a nested IF statement (I believe) to help accomplish all of the scenarios. Here is a screenshot of the charge we need to refer to for the dollar amount to household size. Any help would be greatly appreciated as I am currently stuck on how to accomplish this or even if this is a formula that can be done. Thank you.

Smartsheet Overachievers Alumni

Tags:

• ✭✭✭✭✭✭
Options

I think you would need to put an INDEX/MATCH into your If statement to look at a table that has you income levels matched up to your household size.

• Overachievers Alumni
Options

I will give that a try.

Smartsheet Overachievers Alumni

• Overachievers Alumni
Options

RossL - just a question, if I do an Index/Match from the table, how do I account if the income falls below for each household size?

Smartsheet Overachievers Alumni

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!