Formula

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
-
Hi Saqib,
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.Β (share too,Β andree@getdone.se)
Hope that helps!
Have a fantastic weekend!
Best,
AndrΓ©e StarΓ₯
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!