Formula Assistance

I'm trying to create a automated system in Smartsheet's that takes criteria from a form submission (Unit, Start Date, End Date, Day of the Week and Shift time) to cross check another Smartsheet that has the full calendar year by week and if all criteria from the submission match on the calendar sheet for the particular(Unit, week range, day, and shift time) will subtract from the max available spots using the student count entered in the submission. Is there a formula that can do this? I've tried using a countif formula of all criteria with no success.

Find more posts tagged with

Formulas

Accepted answers

All comments

Ryan Kramer

BKindred6,

I haven't seen anything yet that does stuff this complex but you could complete this task with a small amount of programming and utilizing Smartsheet's APIs.

Basically you could have the script run once a day and go through each entry, calculate the totals by the 5 criteria points and then aggregate and populate into your final sheet or whatever you are using for keeping track of open spots/closed spots.

Ryan

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.