I’m trying to create columnA (If/Then column) that will display a formatted number value based on a condition. The condition looks at the value in columnB (a Math column). If columnB contains a value then it returns that value in columnA. If it has no value, then columnA receives the value from columnC (another Math column). My If/Then works but it loses the number formatting. Is there a way to do this without losing the formatting?
This is a known issue. The workaround is to add another math column at the end to re-apply the desired formatting.
4 Likes
Brilliant! Thank you!