- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 13, 2025 10:20 AM
Hello,
I have created a check Request form in my system. For some of our transactions we will deal with multiple transactions but I only want to have one button. I have created multiple fields (Fee #1, Fee #2, Fee #3, Fee #4, Fee #5). I am trying to create a nested if Statement (or open to other options) to fill the check Request field with the newest fee. For example If Fee 5 is empty but Fee 4 is not then I want Fee 4 populated in the field. If Fee 5, 4, and 3 are empty then I want Fee 2 to populate in the field. And so on. Appreciate any direction.
So far I created a nested if Statement but it only works for the first field then no longer works.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 13, 2025 10:58 AM
will it always be in that order? if so you could try the below. alternatively for something more robust you could use a script to get the non empty fee if only 1 will be populated
IF(
{Fee5}, {Fee5},
IF(
{Fee4}, {Fee4},
IF(
{Fee3}, {Fee3},
IF(
{Fee2}, {Fee2},
IF(
{Fee1}, {Fee1}
)
)
)
)
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 13, 2025 10:58 AM
will it always be in that order? if so you could try the below. alternatively for something more robust you could use a script to get the non empty fee if only 1 will be populated
IF(
{Fee5}, {Fee5},
IF(
{Fee4}, {Fee4},
IF(
{Fee3}, {Fee3},
IF(
{Fee2}, {Fee2},
IF(
{Fee1}, {Fee1}
)
)
)
)
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 13, 2025 11:24 AM
This worked perfect. Thank you. The order always stays the same so this works.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 13, 2025 11:27 AM
my pleasure! 🙂
