Reference cells in excel template , or using a select inside a start

[Power_Manage]

Hello
So I have a workflow rule , generating an excel template.
In that template , I have a start expression which brings filtered table , and a few of its columns.
Now I am trying to run a sum select using this columns .
So how can I reference the select to this columns ?
is it possible through the excel cell or another method ?
I dont want to create a VC for this , so it wont slow down the app load.
Is it possible in any way without a VC column ?

[Marc_Dillon]

help.appsheet.com

Microsoft Excel Email Templates

Using Microsoft Excel email templates.

[Power_Manage]

Thank you for your reference.
I have read everything from appsheet .
I was trying also to create it as a start expression , but I dont know how to reference the cells ( from excel or nested table ) inside this expression .
is it possible ? or we must create a VC for this purpose ?

[Marc_Dillon]

I mainly meant to highlight this part of the help file:

We only support very simple Excel templates.

The first row in the Excel template can only contain column header values. 

The second row in the Excel template can only contain a Start expression, one or more cell data values, and an End expression. 

Your requirements are extremely unclear, but my best guess is that you are wanting to do something that won’t be possible with an excel template.

Perhaps you can (greatly) elaborate on your requirements.

[Power_Manage]

I have attached n image oh what im trying to achieve.
I have another table , which stores date ranges , product and cost price.
I am trying to pull the cost price from that table , inside my table generated from the 1st Start expression.

[Marc_Dillon]

Ahh, yah, that’s definitely not what I was thinking. You don’t need the 2nd START expression there.

And probably need to add in a bunch of [_THISROW-1]. to the SELECT expression.

[Power_Manage]

yes of course I was trying before without a start
Issue is , _THISROW references me to the table which generated the workflow , but not for the table which is generated from the start expression.

[Marc_Dillon]

Try with [_THISROW-1] instead of [_THISROW]

[Power_Manage]

Thanks. I get this error :
Expression ‘SELECT()’ is invalid due to: Expression ‘SELECT()’ could not be parsed due to exception: Object reference not set to an instance of an object…"

[Marc_Dillon]

Power_Manage:

Object reference not set to an instance of an object

This error indicates some problem within Appsheet itself, I believe, and is not really “user-serviceable”. Try it again. If it persists, it might need some help from support.

[Power_Manage]

thank you , I have messaged them .
Is it possible somehow to use the excel cell in the select expression instead of [_THISROW-1].[PROD_UID] for example ?
As it is already there , would have been easier then those [_THISROW-1], which I honestly not fully understand .

[Power_Manage]

Something like :
<<SUM(SELECT(Product Purchases[Price],AND([PROD_UID]=D3,A3>[Start Date],A3<[End Date])))>>

[Marc_Dillon]

No

[Power_Manage]

This is the expression