
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 11, 2023 07:21 PM
Hi there, I'm essentially trying to set up two overwrite fields in my formula. So if field 1 is blank, then use the data from field 2, but if field 2 is blank, then use data from field 3.
I have the formula for one overwrite which works fine (see below), but I can't seem to work out how to add another condition to it.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 12, 2023 05:39 AM
I haven’t tested this, but you should be able to do it like this:
IF( AND({Field 1}="",{Field 2}=""), {Field 3},
IF( {Field 1}="", {Field 2},
{Field 1}
))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 12, 2023 05:39 AM
I haven’t tested this, but you should be able to do it like this:
IF( AND({Field 1}="",{Field 2}=""), {Field 3},
IF( {Field 1}="", {Field 2},
{Field 1}
))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 28, 2023 10:07 PM
You're amazing, thank you! Problem solved 😀
