-
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…