Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
If & AND equals checkbox
Cant get my formula to work =(
=IF(AND([Team]28 = "Street Lighting", (NOT(ISBLANK([Quote Sent Date]28)), 1, 0)))
If Column 1 (Team) contains text "Street Lighting" and Column 2 (Quote sent date) is not blank, Check the box
Thank you in advance