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
Answers
-
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.
-
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!