Formula help

From my sheet I need to populate a checkbox based on these criteria

VDate is less than WDate

AND

Status = Live

This formula is working to accomplish the first criteria but I can't get the status part to work.

=IF([VDate]@row < [WDate]@row, 1)


Thanks for the help, I am horrible at formulas!

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!