Hello,
I use such a formula to read the last previous status from the list
INDEX(LIST1,COUNT(LIST1)).
(List1 is a reference table). This formula is used in the bot to enter the received value into the field in the row where the bot was started. On the preview of the formula, where I test it, it looks all ok. However, when the bot is run it enters a blank value when it uses the virtual column, where this formula is contained, instead of the formula described above. It is all ok. Does anyone know where the problem is?
Are you using the VC in the template?
Could you instead try to update the value directly instead of through a VC such as
<<INDEX(LIST1,COUNT(LIST1))>>
I'm not using template. I'm using in process "Run a data action", and "Set row values", But I can't use this formula
INDEX(LIST1,COUNT(LIST1))
directly in "set row values". I only have to use the VC where this formula is so that it doesn't enter an empty value
Thank you for the update. Not sure why you cannot use it in action. I used it and it set the column value from the expression.
The column expression:
The changed value in the backend sheet:
It looks exactly like mine. Thank you for your time. If I find out anything I will let you know
User | Count |
---|---|
43 | |
27 | |
24 | |
23 | |
13 |