Using a date formula to come up with a dollar amount..??

I need help writing the correct formula for determining a dollar amount within a time range of 90 days.

I have a parent row and underneath are children; projects upcoming within 120 days.

I also have a contract amount listed in another column in respects to each row.

I want to find out the dollar amount of the contracts that are within 90 days; out of the listed 120 day section.

I know that I need to use a date formula but I am not sure how to write the formula properly to come up with the total contract amounts that are with 90 days.

I am a beginner in smartsheets so any insight to do this will be helpful.

Thanks!

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Try something like this...

=SUMIFS(CHILDREN(), CHILDREN([Date Column]@row), @cell <= TODAY(90))

The above is assuming you are putting it in the parent row of the amount column.

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.