Formula "Self-Changing" to Something Else

Looks like you’ve just got some nesting issues with the IF statements. Airtable is attempting to correct so that’s why it changes. (Full disclosure - I asked ChatGPT.)

Hm yeah, I would recommend adding line breaks and tabs to formulas to make them easier to debug

Here’s what your formula looks like:

IF(
	{Transaction Status} = "Order Filled", 
	IF(
		{Transaction Type} = "Sell", 
		(
			{Total Cryptocurrency Value USDT} - 
			(
				{Value per Buy Cryptocurrency USDT (from Linked Buy Transaction (From field: Linked Sell Transactions))} * 
				{Amount of Cryptocurrency}
			)
		) * 
		0.35
	), 
	IF(
		{Transaction Type} = "Buy", 
		IF(
			{Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)} = {Total Cryptocurrency Value USDT}, 
			(
				{Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)}) - 
				{Total Cryptocurrency Value USDT}
			) * 
			0.35, 
			IF(
				{Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)} < {Total Cryptocurrency Value USDT}), 
				'Trade in progress', 
				IF(
					{Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)} > {Total Cryptocurrency Value USDT}
				)
			), 
			'Miscalculation'
		)

There are a couple of extra ‘)’s and the ‘Miscalculation’ line isn’t inside an ‘IF’, which seems like a typo?

Try this:

IF(
	{Transaction Status} = "Order Filled", 
	IF(
		{Transaction Type} = "Sell", 
		(
			{Total Cryptocurrency Value USDT} - 
			(
				{Value per Buy Cryptocurrency USDT (from Linked Buy Transaction (From field: Linked Sell Transactions))} * 
				{Amount of Cryptocurrency}
			)
		) * 
		0.35
	), 
	IF(
		{Transaction Type} = "Buy", 
		IF(
			{Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)} = {Total Cryptocurrency Value USDT}, 
			(
				{Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)} - 
				{Total Cryptocurrency Value USDT}
			) * 
			0.35, 
			IF(
				{Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)} < {Total Cryptocurrency Value USDT}, 
				'Trade in progress', 
				IF(
					{Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)} > {Total Cryptocurrency Value USDT},
					'Miscalculation'
				)
			)
		)
	)
)	

​@TheTimeSavingCo,

Thanks for your reply.

I copied and pasted your version of the code into the formula field, and this time it did not “self-change” the code but where there is supposed to be the text “Trade in progress” for a particular record, it doesn’t show anything. So I’m thinking there is still something wrong with the way the IF statements are nested, or Airtable still isn’t liking the formula. As I can see it, it looks fine to me.

Hmm, your formula currently checks the following: 

{Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)} = {Total Cryptocurrency Value USDT}

IF(
	{Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)} < {Total Cryptocurrency Value USDT}, 
	'Trade in progress',

​@TheTimeSavingCo

I think I have worked out what the problem is with a bit of troubleshooting, but I still can’t find a solution to the problem.

What I did was I switched the positioning of the IF statements for the “Buy” and the “Sell” portions of the formula. So when the “Sell” portion of the formula was at the top (just under the “Order Filled” IF statement), it worked out the Sell amount but not the text for the Buy portion of the formula.

When I switched the formula and placed the “Buy” portion of the formula at the top (above the “Sell” portion and under the “Order Filled” IF statement), then it worked out the “Trade in Progress” text correctly, but no longer showed the amount for the Sell portion of the formula.

So, it is not calculating both the Sell and Buy portions concurrently - only one at a time.

I have no idea what could be causing this problem. It no longer makes any sense to me (other than there being something wrong with how Airtable is calculating the formula). Technically, there is nothing wrong with the formula because they both work when positioned at the top. Have you encountered this before?

I have decided on a workaround to this problem, so no worries about replying to this topic. It can be closed by the mods.