There are so many missing functions which should be added. Just take a look at functions available in Excel for starters. Functions that work on ranges should work on collections or arrays.
Math:sin,cos,tan (and all their derivative) ,abs,sum (across a field in a collection or object), sumif, sumproduct, avg, count, round, countif,countblank,countifs,max,maxif
String: instr, left,right,proper,rept
Conditional logic: ifs,iferror,ifna
Financial:accrint, npv..
The list is so huge, see https://support.microsoft.com/en-us/office/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d9...
Yutao
on:
Cloud Excel - Sort/Filter
on:
Inserting variables inside Scope
on:
Power automate desktop batch processes
AnnaChu
on:
Trigger for when an email is moved to a folder