AnswerBun.com

Blank a column if a condition is met

SharePoint Asked on January 11, 2021

I have a established a custom list with 5 columns for testing.

  1. Title column
  2. Date columns (Date1 & Date2)
  3. Calculated column to count days between the 2 dates (Total)
  4. Calculated column to count how long it was since the first date column was entered (How Long).

What I am trying to accomplish is that when the "Date2" column is filled the "How Long" column will blank out.

Example:

enter image description here

So in this case because there is a date in the "Date2" column I want the "How Long" column to be blank. The current formula for my "How Long" column is simple: =Date1-TEXT(NOW(),"mm/dd/yyyy").

Is it possible to add additional syntax that will blank the "How Long" out when a date is entered into "Date2"?

3 Answers

You can use the ISBLANK Syntax, as Matiur Rahman provided.

But the formula should be:

=IF(NOT(ISBLANK(Date2)),"",Date1-TEXT(NOW(),"mm/dd/yyyy"))

enter image description here

Correct answer by Chelsea_MSFT on January 11, 2021

In order to check if the date column is blank or not, you can use ISBLANK function in your formula.

Example:

=IF(ISBLANK([Date Column]), "Date column is blank", "Date column is filled")

So, in your case you need to update your formula like below:

=IF(ISBLANK([Date2]), [Date1]-TEXT(NOW(),"mm/dd/yyyy"), "")

Reference: IS functions - Check for ISBLANK example

Answered by Ganesh Sanap on January 11, 2021

Try this:

=IF(ISBLANK(Date2),"",Date1-TEXT(NOW(),"mm/dd/yyyy"))

enter image description here

Answered by Matiur Rahman on January 11, 2021

Add your own answers!

Related Questions

How to Set up Search for Extended Web applications Sp2013

1  Asked on February 18, 2021 by allegro-octopus

   

Embed my website content in my sharepoint by URL

2  Asked on February 15, 2021 by hippyjim

   

Customized Form – Sharepoint Online library

1  Asked on February 14, 2021 by elised

 

Extract Excel file names into Sharepoint List

1  Asked on February 13, 2021 by madeline

       

Pinning a document to a SharePoint Home Page

1  Asked on February 11, 2021 by wrightyatwork

       

Recurring Work Flow

1  Asked on February 10, 2021 by curtis

   

Video views counter in SharePoint Online

1  Asked on February 3, 2021 by msiri28

   

Ask a Question

Get help from others!

© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP