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!

Find more posts tagged with

Formulas

Accepted answers

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)

All comments

Hi @Ruth Schoonover

Try this:

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

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)

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

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.