Round up & If Condition

Callsidd

Hi, 

 

Hope this message finds you well.

 

In Ms Excel, we have following function available, how can we have the same in Smartsheet?

 

MROUND(AVERAGE(V2:Y2),0.5)

 

Moreover, need to implement the same formula in smartsheet.

 

IF(OR(AA2>0,AB2>0,AC2>0,AD2>0),"C","NC")

 

Thanks in advance

J. Craig Williams

Callsidd,

 

Smartsheet does not have an MROUND function

(For those who don't know but care: MROUND(number,multiple) is an Excel / OpenOffice function that returns a number rounded to the desired multiple)

 

One could be developed. 

 

Your IF(OR(...) formula looks OK as is for columns named [AA], [AB], [AC], [AD], and row 2.

Did you try it and get an error?

 

Craig 

Callsidd

Thanks Craig for an update. Much appreciated.

 

I've tried IF(or (...) and successfully got expected results but can you please suggest any alternative of Mround function?

 

Regards,

Callsidd

J. Craig Williams

Callsidd,

 

In PHP, the algorithm is about 40 lines of code.

I haven't done it in Python (it is in a package I don't  use), so I don't know how complicated it might be. 

What I mean by that is to duplicate it using only the Smartsheet GUI won't be easy.

At least at first glance.

 

Best would likely be to write the code in the API.

 

If you are willing to pay for a solution, send me an email. 

If not, this is not going to be something I do in my spare time. 

 

I am curious on when you use the formula. Since MROUND rounds to nearest (as opposed to up), it would not be something like "how many teams of three do I need?"

 

Craig