Forum Discussion
Solved
Generating an Formula using concatenation in excel
Hi There, I am planning to generate a formula using concatenation operation in excel and it actually works but the only issue is it’s not executing it just gives the generated formula as output i...
- Interesting. So, the new view you created automatically redirects to the Allitems.aspx (All items view) when updating the URL, from my last reply to your view name?
Another option to try is navigate to your list and select the view you want to gather the URL for. In the browser URL, it will contain an allitems.aspx?viewid=[ID NUMBER]. This allows the view to change to that specific view and bypass your allitems.aspx view.
Or... navigate to list settings and copy the URL of the view name and paste into notepad. You will see within the URL a VIEW=%7B7[view ID]%7D. This will be the view ID and you can update your URL to https://[domain].sharepoint.com/Lists/[name of list]/allitems.aspx?viewid=[ID NUMBER]
This uses the XLM command EVALUATE within Name Manager where it works correctly just as HansVogelaar 's solution. With 365 the process can be taken a step further and the name can be a Lambda function.
EVALUATEλ
= LAMBDA(formula, EVALUATE(formula))The sole advantage is that EVALUATEλ can be reused with multiple strings.