Formula help

Ruth Schoonover

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!

ker9

Hi @Ruth Schoonover

Try this:

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

Ruth Schoonover

@ker9 This one worked, thank you!!

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

ker9

Hi @Ruth Schoonover

Try this:

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

=Chris Palmer

Hi @Ruth Schoonover,

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"

Ruth Schoonover

I am getting an unparseable error on that formula.

Ruth Schoonover

@ker9 This one worked, thank you!!

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

Mark Boxley

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

Genevieve P.

Hi @Mark Boxley

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

See: Use Formulas to Perform Calculations With Dates

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

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

Cheers,

Genevieve