-
Average of Column
Hello! I was wondering if anyone knew of a way to get an average of a column. I know we can get an average of a specific range in a column, however this sheet I'm working on is a survey and there will be ongoing entries. If possible I just want to get the average of the whole column so I don't have to come back and update.…
-
Multi Criteria Formula
I need to create a formula that filters rows based on several criteria. The formula should show rows between specific date periods for the ‘Date Created’ and ‘Date Closed’ columns. For example, rows created between 01/01/23 and 02/01/23. Next, the formula should break those rows into counties based on the ‘County if…
-
How do I turn off the pop-up messages while editing a formula in Summary fields?
These pop-ups block what I am editing. If I close one, then click to edit, another pops up - over and over. If I stretch my screen, they will pop up on the side - but then popup over what I am editing. I have to move re-stretch my window EVERY time I try to edit a Summary field..
-
Formula not working
Can someone please help me with this formula? I've worked on it since 7:30 am it's now 10:15 am. =COUNTIFS({complaints Range 1}, NOT(ISBLANK(@row)), {complaints Range 2}, >=DATE(2023, 1, 1), {File a complaint Range 3}, <=DATE(2023, 12, 31))
-
Clone cells or rows?
Hi All, Hope you are well. We currently use Smartsheets as part of our product management and planning. We have a Sheet with all our current development work some of which has been started and some of which has not been started, the problem is this sheet is getting quite big with all our current and upcoming work its named…
-
6 Month Anniversary Formula
Hello Everyone, I am an excel wiz but I realize formula writing is totally different within smartsheet. I need help projecting 6 months in advance date. I used the following formula. =DATE(([Start Date]6) + 1),(([Start Date]6) - 6),([Start Date]6)). Any help would be great!
-
VLOOKUP on a multi-select column
Hello, Say I have a multi select column with 4 possible choices (North, South, East, West). If North and South are selected, is it possible to write a VLOOKUP to pull the first selection, and then write a second VLOOKUP to pull the second selection? In other words, is it possible to parse multi-select columns? Thank you.
-
I am trying to create an IF formula with a +/- range!
Hello! I am trying to create an IF formula where if the value is 40% with a range of +/- 2%, it is a pass. If it is any percentage outside of the range (38%-42%), then I was it be a fail. Here is the chart in reference! Any help would be amazing.
-
Stacked bar chart formula using COUNTIFS and HAS functions
I have created a helper sheet to use for building a stacked bar chart. The sheet data should count how many open tasks an individual is assigned to from two different sheets. Because there may be multiple contacts in an Assigned To column, I need to update this formula by adding HAS. I cannot get it to work correctly in…
-
Date Formula
Hello! I have created a sheet, that based on the month, a workflow will be triggered to send an email out on a certain date. For example, if the month is August, Sept or October, an email be triggered to be sent on 12/15/23. If Nov, Dec or January is checked, then the email will be triggered to be sent on 3/15/23.…
