I have a column named Row(s) - Enumlist and in the form, I need it’s last valid value + 1 preselected.
for eg., if last value in Row(s) is Row 1 then I preselected value should be Row 2
I wrote below expression in Initial Value.
LIST(ANY(SELECT(Row[Row(s)], ([Row_ID] = ANY(ORDERBY(FILTER(“Row”,ISNOTBLANK([Row(s)])), [Completion Timestamp],TRUE))), TRUE)))
It’s giving me result “Row 1”. how can I increment it by 1? I need Row 2 as result.
Any suggestions would be great. Thanks.