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


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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!