Creating Column

Question

Hi&nbsp;I want to create a column called 'Needs Action' where a 1 is inserted if Scheduled Date field has a date in it and the Actual Date field is blank.&nbsp; Can anyone tell me how I would do this please&nbsp;tamerj1&nbsp;goncalogeraldes&nbsp;&nbsp;

greg_deckler · Accepted Answer

spandy34&nbsp;Try:
Column = IF( [ScheduledDate] &lt;&gt; BLANK() &amp;&amp; [ActualDate] = BLANK(),"Needs Action",BLANK())

Forum Discussion

Creating Column

2 Replies

Related content

Create columns group

Creating a date column

Creating a custom column

unpivoting columns and creating datetime column

create custom column concatenated