cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
earlbrian
Helper II
Helper II

Using formula in Calculated Column

Hi!

 

Hoping that someone might help me with this confusion.

 

I have a Review End Date and Time column and a helper column (REDT Helper 1). The helper column value is a Review End Date + 1 day.

 

What I want to achieve is the following

- If Review End Date and Time has no value, leave the REDT Helper 1 column blank

- If Review End Date and Time has a value, REDT Helper 1 column will be Review End Date and Time + 1 day

* The Review End Date and Time has no default value in the column settings, it's set to "None"

 

Screen Shot 2021-02-10 at 10.50.16 AM.png

 

My current formula is =[Review End Date and Time]+1 which works perfectly if  Review End Date and Time has a value, but as shown on the image, if value in Review End Date and Time is blank it displays an invalid date.

 

Screen Shot 2021-02-10 at 10.56.39 AM.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
manuelstgomes
Community Champion
Community Champion

Hi @earlbrian 

 

You need to check if it's empty or not. Please try the following formula:

IF(ISBLANK([REDT Helper 1]),"",[REDT Helper 1]+1)

 

Screenshot 2021-02-10 at 08.58.06.png

 

 

Cheers
Manuel

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

2 REPLIES 2
manuelstgomes
Community Champion
Community Champion

Hi @earlbrian 

 

You need to check if it's empty or not. Please try the following formula:

IF(ISBLANK([REDT Helper 1]),"",[REDT Helper 1]+1)

 

Screenshot 2021-02-10 at 08.58.06.png

 

 

Cheers
Manuel

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Perfect! Thank you @manuelstgomes 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (5,476)