IF Formula

Hello,

I am struggling for while creating one formula.

In my Smartsheet I have Column "Status" with different statuses from a dropdown. One of them is Completed. I also have a Column "End Date" where different dates are being selected.

I want to create a Column "Last 14 days" and one "Next 14 Days" for a report. I need a formula that automatically fills in this columns with yes or no.

In "Last 14 days": Display Yes, if Status =Completed and End Date lies in the last 14 days.

In "Next 14 days": Display Yes, if Status =Completed and End Date lies in the next 14 days.

I am trying this but it does not work for me.

=IF(AND(Status = "Completed", End Date =< TODAY (-14)()), [Last 14 days], yes, no)

=IF(AND(Status = "Completed", End Date =< TODAY (+14)()), [Last 14 days], yes, no)

I hope someone can help.

Thanks

Veli

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!