I know that Smartsheet does not currently support creating formulas from a report. Any formula manually entered in will display as plain text rather than performing a calculation.
I am not sure how the would work, but it would be nice to have a way to enter a formula into a report and have it calculate. I envision this as maybe being the opposite of using the single quote character to prevent a formula from being evaluated. Instead, there would be a reserved work to instruction a report to perform a function, something like FUNC() or REPORTFUNC() which would then evaluate the formula in between the parenthesis.
That is, for a Smartsheet Sheet, if you type =1/2 in a Text/Number column, it appears in the cell as 0.5. If I do that in a Smartsheet Report, in the same cell as the sheet, it appears as the text of =1/2 (that is, equal sign symbol, the numeral 1, the forward slash symbol, and the numeral 2). And if you go to the sheet after typing =1/2 in the cell, it appears as '=1/2. I understand why that make things easier for making Smartsheet work. What I want is a way to override it without needing to go to the sheet to enter the formula.
Maybe it could be entered as REPORTFUNC(=1/2) and Smartsheet would know to evaluate that simple formula.
I guess the complication comes when you enter formulas with ranges. What range are we talking about? In the report or on the parent sheet for the cell. Interesting challenge.
Anyway, just some thoughts to maybe get the creative juices going among the community.