Formula

Options
SBash
SBash ✭✭✭✭
edited 12/09/19 in Formulas and Functions

HI Team,

Do we have substitute to these symbol in Smartsheet or how we can use these function in Smartsheet

">"

&

i have build this formula in excel and its working fine, but i am getting error in smartsheet

 

IF(K$1>MONTH($B$3)+$A27,IF(SUM($C25:$N25)=0,0,(K25/SUMIF($C$1:$N$1,">"&MONTH($B$3)+$A27,$C25:$N25)*($P27-SUMIF($C$1:$N$1,"<"&MONTH($B$3)+$A27+1,$C27:$N27)))),K26)

 

Many Thanks for your support

Saqib

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!