-
Count if cell has a number (not blank or text)
I'm trying to find a formula that will count a cell if it is a number (vs. blank or has text). My original formula didn't take text into consideration, so I'm starting with a simple COUNT formula: =COUNT([Name]8:[Name]58). I assume I need some kind of COUNTIF formula, but am not sure how to reference numbers in general.…
-
Counting # of rows that match a number range
I am trying to create a sheet summary formula to count the number of projects that are within a number range (# of days out or past). I am not sure what function or formula to use but I created a formula like this that isnt working: =COUNTIFS([# of days to Finish Date]:[# of days to Finish Date],=>0,([# of days to Finish…
-
Help with date range formula
Hi, I have a sheet with a "Helper Date" column and a column which shows if a participant registered for an event or not. I'm looking for the total of registrants (attended or not) during a quarter of a year. I have two formulas that work now: The amount of events per quarter: =COUNTIFS([Helper Date]:[Helper Date],…
-
Use a blank "Column Name"?
Is there a way to leave the "column name" blank for a Smartsheet column? Or, alternatively, input a blank placeholder (character or otherwise)? Why? I don't want any words, spaces, symbols showing up in the Smartsheet Calendar app from this "column name" but I do want the data within the column to show up on the Smartsheet…
-
I would like to pull data from one smartsheet into another
I'm sorry to be asking this question, I've been struggling for several days. My background is sql against rational databases. In sql, I would like to join together 2 tables and grab the data in column Z from the second table when the values match in both tables on a specific column (not providing the value in the statement…
-
Counting 2 different Columns?
I am in need of some help. I can't seem to figure out how I am to get a count of how many people selected a certain salad with a certain protein. I have one column that participants are picking a lunch item. Two of those items are salads. I put the formula =COUNTIF([Sunday, January 23rd Lunch]:[Sunday, January 23rd Lunch],…
-
Is there a way to easily/quickly hyperlink 100's of sheets.
I am running into an issue where it is desired that 100's of sheets in a workspace have an individual hyperlink on a separate sheet. The desire is that in card view, they can click on the hyperlink and go directly to that person's individual sheet. I understand that the desired effect can be obtained by running a report…
-
Date formula
Hello, I need help with a date formula, I need to enter a date and once enter 10 weeks are subtracted from that date. New date will be displayed. Thank you.
-
Formula to pull the non-blank value from multiple columns
Not sure if this is possible but I'm trying to pull a non-blank value from one of multiple columns and paste it in a separate column. Essentially, there are 5 columns that are Department (Deburr, Lathe, Mill), Deburr Machine, Lathe Machine, Mill Machine, and machine (think of this column as the master column, or…
-
Overwriting column formulas
Hi folks, I've got a lovely column formula doing what I wanted it to be able to do. But, it seems that individual cells in the column are now uneditable. That was not my plan! Is there anything I can do to make the column formula apply in the first instance but then allow the cell to be editable in the second instance?…