Looking for help with a formula that wont allow a selection if tow other fields have requirements

We are using Smartsheet to track system request as a PMO and Approval tracking. We have a field we select the Approver from to get this automated workflow to kick off however depending on the complexity it my require 1 or 2 UAT (User Access Testing) and want to ensure our users if one or both are required they cant select the Approver till its populated.

Per the Logic below IF UAT1 is Required or IF UAT is also required the user cant select "Request Approved By" till there is values entered in the UAT1 Completed On/UAT2 Completed On.

IF 'UAT 1' = Required 'UAT 1 Completed On' must have value to allow the "Request Approved By" to be entered

IF 'UAT 1' = Required AND 'UAT 2=Required THEN 'UAT 1 Completed On' AND 'UAT 2 Completed On' must have value to allow the "Request Approved By" to be entered

Find more posts tagged with

if formula

Accepted answers

All comments

Darren Mullen

@k_Hunter001 Smartsheet can't perform that type of validation in a grid view. The only view in Smartsheet that could do that type of validation would be Dynamic View.

Otherwise, you'd have to use another 3rd party form solution that can enforce that type of logic.

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.