Using formula in Calculated Column

[earlbrian]

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"

 

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.

 

[manuelstgomes · Accepted solution]

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)

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.

[earlbrian]

Perfect! Thank you @manuelstgomes