Hello,
I'm trying to recreate/transfer a salary/reward solution in Excel over to Smartsheet and two of the columns have a rather complicated formula, which has a function I don't believe is available in Smartsheet (COUNTA). When I've tried to replicate it I get an error message (UNPARSEABLE) The formulas are:
=IF(SUM(AR13:AT13)>0,IFS(OR(AU13="",AV13=""),"Please enter review reason and detailed explanation",COUNTA(AR13:AT13)>1,"Please enter one type of increase recommendation only",AR13<>"",ROUND(AR13*V13,0),AS13<>"",ROUND(AS13*U13,0),AT13<>"",ROUND((AT13-AL13)*U13,0)),0)
=IF(SUM(AR13:AT13)>0,IFS(OR(AU13="",AV13=""),"Please enter review reason and detailed explanation",COUNTA(AR13:AT13)>1,"Please enter one type of increase recommendation only",AW13<>"",AW13/V13),0).
I'm wondering if anyone knows what other function I could use to get these work in Smartsheet. I did try COUNTIF, but it didn't work either.
For reference, this is what they look like Excel - they should bring up a salary increase numerically and a percentage respectively.