Returning a value of 1 of 3 cells
I have 3 columns. [REQ Amount], [PO Amount], [INV Amount]. I want another column [Amount] to be the most relevant "amount" . At first a REQ is done for say $2. Then a PO is sent for the said REQ but gets messed up and issued for say $3, then my actual cost might be $3. Then the invoice comes in at $2. So when the invoice is paid, I want the $2 to be my most relevant expense amount.
How do I write a statement that says if INV Amount and PO Amount are Null, then REQ Amount, Else if INV Amount is Null then PO Amount, else, INV Amount?
Thoughts?
Best Answer

Good Afternoon,
I want through your scenario above and believe an IF statement formula would solve your most relevant "amount" column.
This is the formula I wrote and the scenarios I tested are blow.
=IF([INV Amount]@row = [PO Amount]@row, [REQ Amount]@row, [INV Amount]@row)
Please let me know if this helped!
Answers

Good Afternoon,
I want through your scenario above and believe an IF statement formula would solve your most relevant "amount" column.
This is the formula I wrote and the scenarios I tested are blow.
=IF([INV Amount]@row = [PO Amount]@row, [REQ Amount]@row, [INV Amount]@row)
Please let me know if this helped!

Hi Kayla, good afternoon to you as well. This kinda works. In the end, the most relevant number is the later one in the process. So I'm encumbering with a REQ $2 from a budget, until a PO is done, then the $2 is superseded by a $3 PO... until an invoice is received then the INV $2 supersedes the PO. Does that make more sense?

EUREKA.. i GOT IT! Thanks for the insights!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 321 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 277 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!