Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Round up & If Condition
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 
Comments
-
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
-
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
-
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
