How do I do this on Smartsheet? I have an Actuals and a Budgets column. I'd like to compare the 2. So for example, if you have a Budget of 100, and an Actual of 70, then the variance would be -30%.
IFERROR((Actual-Target)/Target,0) is all good for positive numbers but I need to ensure it also works for negative numbers.
In Excel, this works using IFERROR((Actual-Target)/ABS(Actual*(Target=0)+Target),0).
How do I get a similar formula to work in Smartsheet?
Thanks