Formula help

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

VDate is less than WDate


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!


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!