-
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?…
-
Indenting on smartsheet causing calculation error- help?
Hello, My organization uses smartsheet as a scheduling tool. We have a column that calculates what resource hours we have remaining for available scheduling (formula =((# of crew members * work days * work hours) - SUM(CHILDREN())) in my case specifically, =((8 * 5 * 7) - SUM(CHILDREN())) ) If a work order has multiple…
-
Countifs plus a date range?
Hello, My sheet has a column with due dates across the year. I would like to count how many are due each month for a forecast report to show # due in Jan, # due in Feb, etc. How do I write the formula for the date so that it includes all days of each month? =Countifs [Adjusted Due date]:[Adjusted Due Date],…