SharePoint Asked on January 11, 2021
I have a established a custom list with 5 columns for testing.
What I am trying to accomplish is that when the "Date2" column is filled the "How Long" column will blank out.
Example:
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"?
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"))
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
1 Asked on February 18, 2021 by allegro-octopus
1 Asked on February 17, 2021 by sylvie
1 Asked on February 15, 2021 by ola
2 Asked on February 15, 2021 by hippyjim
1 Asked on February 15, 2021 by bobbywestside
1 Asked on February 13, 2021 by madeline
1 Asked on February 12, 2021 by zacc
0 Asked on February 11, 2021 by danj
1 Asked on February 11, 2021 by wrightyatwork
1 Asked on February 10, 2021 by vishwanath-mishra
1 Asked on February 8, 2021
2 Asked on February 6, 2021 by mikey
1 Asked on February 4, 2021 by mee
1 Asked on February 4, 2021 by mirjam-kaal
1 Asked on February 3, 2021 by msiri28
1 Asked on February 2, 2021
1 Asked on January 29, 2021 by gaelle
Get help from others!
Recent Answers
Recent Questions
© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP