isnotblank formula
Discussion List
- Hello, I am trying to create a formula for one sheet to search another sheet based on a PO#, and return the value of the latest PO revision. I'm trying to make this work without adding a helper column…
- Hello Everyone, Hoping that someone can help me out please. I am trying to do a COUNTIFS formula with NOT / OR plus ISBLANK function. I was able to build where I can get count of ABC units that are NE…
- I would like to have a cell either be blank or have a checkbox if another cell is blank/notblank. Basically I want to have something like: =IF(ISNOTBLANK(Monday@row) = Create Check box Otherwise leave…
- Hi Community! I have two different grid sheets within smarthseet with the following information: In sheet 1 I have several products that need a certain number of photography shots and being delivered …
- I am stuck getting this to work and have been trying both ISERROR and ISBLANK but keep getting an UNPARSEABLE error. Here is the overview of what I need to do: First, I have a column [Cumulative Delay…
- Hello! I am working on a formula to calculate the percentage of boxes checked. This formula is currently working when I set the range to exclude the blank cells. However, I need to allow space for mor…
- I had a formula that was working all through the trials but then right before the roll out it stopped working! In one cell there's a column that Auto counts Responses no big deal there. In a cell in a…
- How do I make this formula operate the way I need to. If there isn't a due date or a status, I don't want it to get flagged as at risk yet. =IF(OR(Status@row = "Completed", [Due Date]@row = " "), 0, I…
- Hello! I've been working on this formula for hours now and could use some help. I have a column called "Program Date" and a column called "TR". If Program Date is between 12/1/24 and 4/30/25 AND TR is…
- I am trying to find an equation that will help me reference text found in multiple different columns to a master column. My "master column" is the column titled "SO Program". Based on the answers bein…