-
Using DISTINCT function
I am trying to use the distinct function. It seems like it should be relatively simple, but I am getting an error message. Am I doing something wrong? Thanks
-
Counting Blank Cells
I need assistance on counting all rows that are blank based upon a status column The formula I used is: =COUNTIF({Status Blank}, HAS(@cell, "--")). and I tried using this formula: =COUNTIF({Blank Status}), ISBLANK(@cell)) The "Status Blank" is referencing the other sheet.
-
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…