IF Function to Deliver Target

MattJ

How do I build a formula with two variables to deliver a target date?

Example: IF cell A = defined variable and cell B = defined variable, then cell D = 6 months from date reflected in cell C. I can do this in excel using IF and Edate functions, but can't figure out in Smartsheet. Any assistance would be greatly appreciated? 

Andrée Starå

Hi Matt,

Try this.

=IF(AND(A@row = "Value"; B@row = "Value"); C@row + 180)    

The same version but with the below changes for your and others convenience.  

=IF(AND(A@row = "Value", B@row = "Value"), C@row + 180)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting