Using formula in Calculated Column

(0) Share

Report

Posted on by 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"

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

All responses (2)

Answers (1)

earlbrian 67 on at

Like (1)

Report

Re: Using formula in Calculated Column

Perfect! Thank you @manuelstgomes
Verified answer

manuelstgomes 6,625 on at

Like (1)

Report
Re: Using formula in Calculated Column

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.