Combining If/then with date population

I am trying to figure out a way to auto-populate a date, but only IF a specific condition is met. (Screenshot below)

I used the formula =WORKDAY([1st Test Date] 1,6) to auto-populate the "Second Test Scheduling Date", but I would like this to only auto-populate if the column "1st Test Results" is "Positive".

Any tips? I'm definitely running up against a wall on this one!

Find more posts tagged with

Healthcare

Formulas

Conditional Formatting

Accepted answers

Stefan

Hi @Megan T,

you need to combine WORKDAY with IF

https://help.smartsheet.com/function/if

Logic is: IF the cell "1st Test Results" has the value "Positive", then use the WORKDAY formula, IF not, leave blank.

=IF([1st Test Results]@row = "Positive", WORKDAY([1st Test Date] 1,6), "")

Hope this helps

Stefan

All comments

Stefan

Hi @Megan T,

you need to combine WORKDAY with IF

https://help.smartsheet.com/function/if

Logic is: IF the cell "1st Test Results" has the value "Positive", then use the WORKDAY formula, IF not, leave blank.

=IF([1st Test Results]@row = "Positive", WORKDAY([1st Test Date] 1,6), "")

Hope this helps

Stefan

Brianne Laird

Hi @Megan T

The new Healthcare Community Group is now live! This group is a space for all things Healthcare and your question sounds like a great use of a discussion post in the group. I encourage you to ask questions, share use cases and collaborate with others in your industry. We will also have some excited healthcare-related updates being announced in the Healthcare Community Group very shortly.

Please let me know if you have any questions about the new group!

-Brianne

Megan T

Thanks, all!

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.