Forum Discussion

klb0066's avatar
klb0066
Frequent Visitor
8 years ago

if statement

Creating a splicer with title "Has Due Date?" with True or False checkboxes. Coded an if statement that recognizes if field was left bank then it is false and if the field has a date it is true.   ...
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi klb0066

Create a calculated column

overdue = IF(ISBLANK([target]),BLANK(),IF([date]>[target],1,0) )

 

Best Regards

Maggie