sharepoint list form customization with a conditional formula to show column when other field is not empty

NO 21 Reputation points
2022-03-21T17:50:56.357+00:00

I want edit a form list with a conditional formula in a column. I need that a field will be showed only when a date column will be filled.

For example: when ExitDate is filled --> show column

After check official documentation, I tried with formula:

=If(ISBLANK([$ExitDate]),'false','true')  

but it looks no valid :(

Microsoft 365 and Office | SharePoint | For business | Windows
0 comments No comments
{count} votes

Answer accepted by question author
  1. Grace8786 75 Reputation points
    2023-07-11T06:12:48.6966667+00:00

    =if([$ExitDate],'false','true')


2 additional answers

Sort by: Most helpful
  1. CaseyYang-MSFT 10,466 Reputation points
    2022-03-22T02:27:26.837+00:00

    Hi @NO ,

    You could use following formula:

    =if([$Remark] == ' ', 'true', 'false')  
    

    For example: I want to hide "Action" when "Remark" column is empty.

    185441-empty.jpg


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. Grace8786 75 Reputation points
    2023-07-11T06:14:12.3833333+00:00
    =if([$ExitDate],'true','false)
    
    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.