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.
Solved! Go to 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.
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
3 | |
3 | |
2 | |
1 | |
1 |
User | Count |
---|---|
11 | |
11 | |
6 | |
6 | |
5 |