-
If And Formula including dates and isblank
Hello, I am trying to create a formula that will flag the column Delivered Out, if the On Hand Inventory is equal to 0 and the Date Delivered is today or in the past. Both conditions must be met so if On Hand Inventory or Date Delivered Out is blank, it does not flag Delivered Out.
-
Date Added when my Primary Auto Populates?
Hello! I am trying to find a way to use an automation or something of the sort for when a specific cell is no longer blank. Context: Primary Column is linked to a hidden auto-numbering column The "Date Added" Column was working for a while but every now and then the sheet will add about 5+ empty but numbered rows at the…
-
Issues with Convert to Column Formula
Hi, I have a column that I'm trying to convert to column formula but won't because "The column formula syntax isn't quite right" and gives me Smartsheet's help article for more information. The column's type that I'm trying convert is "Symbols" and is the Progress Bar. The Formula of the attached example is: =IF([RPM %]851…
-
What formula do I use for my needs?
I have 2 sheets (see screenshots) and what I need is to have the Associate Name from the Associate List sheet copied to a column in the Permissions sheet but only if certain criteria is meet. If there is a date in the Yard Access AND GTDR Expiration columns, I need the Associate name listed in the GTDR Certified column on…
-
Help with Index/Match + if blank
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 to the sample data sheet. Here is sample data: The result I want in a separate sheet: I came up with two possible solutions…
-
COUNTIFS with NOT / OR plus ISBLANK.
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 NEW and are not Completed or Cancelled. Worked: COUNTIFS([Unit Name]:[Unit Name], "ABC", [Unit Type]:[Unit Type], "NEW",…
-
Possible to create a checkbox is cell is not blank Otherwise make cell blank
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 cell blank. Is this possible?
-
How to count several non-blank rows based on specific criteria across two sheets
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 in different channels. Each row has a due date. In sheet 2 I want to find a formula that would give me the numbers in blue.…
-
Help with ISBLANK on column formula
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 for Start Date] that increments based on other values for a row. The second column is the base starting date [CALC DATE]…
-
Percentage of check boxes - Need to exclude blank cells
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 more rows to be added in the course name column in the future. I would like to make this formula to exclude those blank cells…
-
Update to Is Not Blank Formula?
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, IF(AND(Status@row <> "Completed", [Due Date]@row - TODAY() <= 3, [Due Date]@row - TODAY() >= 0), 1, 0))
-
Hello,
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 different column =MAX([Row ID]:[Row ID]) // this counts the largest value so I can record the latest response In another…
-
Formula Help Needed - Return "50" if date is within a range AND another field is not blank
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 not blank - then I need it to return the value "50" in my "Cost" column. This is where I am at so far: =IF(AND([Program…
-
Master Column to Reference Answer from Multiple Columns
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 being submitted from my form, I would like the answers/text to to populate to the 'Master Column'. So if 'SO Malaysia' is…
-
Sheet Summary Formula to count text cells that are not blank
Hello, I am having a hard time setting up this formula in Sheet Summary =COUNTIF([Core Customer Name]:[Core Customer Name], "ISNOTBLANK" Can someone help?