Solved: IF Text and Date

HenryJS · ‎03-31-2020

Hi all,

How can I create a column which states Yes IF:

Thank you

az38 · ‎03-31-2020

try a column

Column = 
IF([Document] = "Self Billing Agreement" && DATEDIFF([docexpiry], TODAY(), MONTH) <= 1, "Yes", "No")

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

az38 · ‎03-31-2020

try a column

Column = 
IF([Document] = "Self Billing Agreement" && DATEDIFF([docexpiry], TODAY(), MONTH) <= 1, "Yes", "No")

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

IF Text and Date