web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Using formula in Calcu...

Power Automate

Answered

Using formula in Calculated Column

(0) Share

Report

Report

Posted on by earlbrian

67

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

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

manuelstgomes 6,625 on at

Like (1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
earlbrian 67 on at

Like (1)

Report
Copy link

Link copied!

Perfect! Thank you @manuelstgomes

Was this reply helpful? Yes No

Join the conversation