# Formula help

Options

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:

• ✭✭✭✭✭✭
Options

Try this:

=IF(AND([VDate]@row < [WDate]@row, [Status]@row="Live"), 1, 0)

Options

@ker9 This one worked, thank you!!

=IF(AND([VDate]@row < [WDate]@row, [Status]@row="Live"), 1, 0)

• ✭✭✭✭✭✭
Options

Try this:

=IF(AND([VDate]@row < [WDate]@row, [Status]@row="Live"), 1, 0)

• ✭✭✭✭✭
edited 04/19/23
Options

Give this a try, and let me know if it works for you:

=IF(AND(Status@row = "Live", VDate@row < WDate@row), true, "")

Please make sure the column properties where you have this formula is set to "Column Type: Checkbox"

• Options

I am getting an unparseable error on that formula.

Options

@ker9 This one worked, thank you!!

=IF(AND([VDate]@row < [WDate]@row, [Status]@row="Live"), 1, 0)

• Options

New to Smartsheet ..... looking for the formula to calculate what the finish date would be based on inserting "start date" and "Number of Days"

• Employee
Options

If you aren't looking at "working days", then you can simply use the + symbol to add your number to the Date and it will return another date:

=[Start Date]@row + [Number of Days]@row

If you need to exclude weekends, then you can use the WORKDAY function:

=WORKDAY([Start Date]@row, [Number of Days]@row)

Cheers,

Genevieve