Hello all - I'm looking for some formula help. Without getting to deep, I'm looking to develop a formula that can extract the emails from Latest Comment, regardless of their position in the comment, i…
When creating an auto-number column, if you choose anything different than Numerical Places being 0, it will detect the column as text. Therefore, making calculations with the auto-number column behav…
I want to be able to type in the field if the Value is False. I can copy the formula to all the field in the column and overtype the formula. but if I convert to a column formula then I cant do this. …
Hi One of my sheets has around 40 columns in it! And sometimes it's hard to locate a specific column (given the sheet has 40+ columns!) My present workaround is to (a) create a temporary report, (b) a…
Hello, I am trying to use the auto number system and am having a little trouble. You can see in the first image that I have programed it and the preview is pictured as well. First cell should populate…
Right now, on reports, you can add a column, sort by it, and then remove the column and the sort remains (at least when I test it, it does). However the Sort menu shows blanks. This can also be a tedi…
Hello all. We have a Sheet and sometimes users forget to add important fields. We want to add default values to these fields in order to not be empty. The types of columns that need to have default va…
Is there a way to hide columns and then save that column-hidden configuration? And recall it late. The same as "Filters" do for rows, except for columns.