-
Merged: Hiding columns should work across all views
This discussion has been merged.
-
Keep auto number as number, do not turn it into text when using Numerical Places.
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 behaves different depending on the properties used. For example, the formula =[Row ID]@row + 1 shows different outcomes as the…
-
The IF function
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. Any ideas?
-
How to find a column
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) add the above sheet to it, and (c) type the column name in the column selector! This way if the column exists then its name…
-
Conditional Formatting for Duplicates
Adding the ability to do conditional formatting by column, similar to how I would flag a column for duplicates in Microsoft Excel.
-
Trouble with Auto Number column type. Shows up different in cell.
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 as C001. From the second image, you can see how it populates in the cell. It is stating with the number C011 instead. Can…
-
How do you limit items in a dropdown menu field based on the selection of another?
We're building a process where users are limited to a secondary dropdown menu selection after selecting an option from another dropdown field. For example: We have a Job Department field and a Job Type field. If the Job Department dropdown menu includes Accounting, HR, IT, etc., we want the Job Type field to be limited to…
-
Report Sorting on Non-Included Columns
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 tedious process - adding columns just so you can sort by them and then remove them. The Filter function on a report works on ALL…
-
Default values in Columns
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 values are: Text/Number, Contact List, Dropdown List. We have tried a way to add default values with workflows on Dropdown…
-
Set up hidden columns like "Filters" do for rows.
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.