Switch(ThisItem.Ship,
true, If(ThisItem.Called && ThisItem.Hit, "Fire",
ThisItem.Called && !ThisItem.Hit, "Radar",
"BlueAnchor",
false, "Dot")
)
Switch(ThisItem.Ship,
true, If(ThisItem.Called && ThisItem.Hit, "Fire",
ThisItem.Called && !ThisItem.Hit, "Radar",
"BlueAnchor",
false, "Dot")
)
If(
ThisItem.Ship,
If(
ThisItem.Called && ThisItem.Hit,
Fire,
ThisItem.Called && !ThisItem.Hit,
Radar,
BlueAnchor
),
Dot
)
Switch(ThisItem.Ship,
true, If(ThisItem.Called && ThisItem.Hit, Fire,
ThisItem.Called && !ThisItem.Hit, Radar,
Anchor),
false, Dot
)
@WarrenBelz I was initially getting an error that it expected an image value. The quotes removed that error, but it appears that the other error was the whole problem. Here is the modified working formula. Note that I removed the 'true' value after ThisItem.Ship. ThisItem.Ship is already a true/false value and adding true gave another error.Switch(
ThisItem.Ship,
true,
If(
ThisItem.Called && ThisItem.Hit,
Fire,
ThisItem.Called && !ThisItem.Hit,
Radar,
BlueAnchor
),
false,
Dot
)