- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 12, 2023 06:05 PM
Hi All,
I'm having an issue figuring out how to best format a formula for my situation.
This is probably very simple but I need a hand.
Here are my fields:
"Total" - Currency field with numeric value
"Total Copy" - Formula Field
"Is Income?" - Single Select field
Basically, I need Total Copy to take & convert Total's value to a negative or positive number based on Is Income.
But now I need it to also recognize if Is Income is not empty so it can copy from Total and deliver a positive value instead of staying blank in that case.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 12, 2023 06:39 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 12, 2023 06:39 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 12, 2023 07:27 PM
Exactly what I mean! Thanks so much. I think I was just overcomplicating it in my head 🙂
