How to access the indentation in the formula bar?
AnsweredI was writing a SUMIFS formula in my Workiva spreadsheet and I would like to use indentations. I see on this guide (https://support.workiva.com/hc/en-us/articles/360035643052-Use-formulas) [See Advanced Formula Editor] it is possible. Yet, I am not seeing that option.
How do I use this feature?
-
Joshua Wallis I glanced at this when you first posted it and was interested as I had never heard of this feature (Advanced Formula Editor). Then I forgot all about it, but today I visited that same article for another reason and saw this feature mentioned again. Excited, I also went to try to use it, but like you, I seem to be unable to turn it on. When I expand the formula editor area in my spreadsheet it just uselessly adds more whitespace, as shown in your screenshot. There is no expansion of the formula with automatic line-breaks/indentation (what I was after).
1
Welcome to the Community Joshua Wallis and welcome back Andrew McKenzie,
Unfortunately, support for the Advanced Formula Editor was removed a number of years ago. It looks like our support article is woefully out of date. I do apologize for that and thank you for bringing this to our attention. There are efforts in progress, though not prioritized, to bring back the Advanced Formula Editor. No ETA at this time but we'll keep you posted if that changes!
0
Thanks Isabel Messore for the clarification. It certainly seemed like a useful feature, so I hope it is brought back soon.
0Please sign in to leave a comment.
Comments
3 comments