-
Sheet Formula
Happy 2024 everyone, I hope your year is off to a great start! I'm back requesting help to get some formulas working. I am trying to use the countif formula to count a column in a sheet. I am trying to get it to count all the dates in the column, but I also want to use to the formula to count all the rows with that same…
-
Override Column Formula for Particular Cells
It would be great if we could edit single cells within a column that has a column formula in place without having to convert it back to a Cell Formula! That way if we have accurate data for one cell, we can change it and still keep the formula for the rest of the column!
-
Change calendar (column type: date) to years (not months)
Hi all, Just a quick question - when using the column type 'date' in a sheet, is it possible to make the calendar which comes up for selecting the date in question a 'year' calendar rather than a 'month' calendar? Many people using the sheet/form will be inputting dates from about 50 years ago, so a calendar by month…
-
Contact Formula from Latest Comment Column
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, if/when they are added in the latest comment. I currently can move (1) email but not multiple ones. I then put it in a helper…
-
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…
