Summary Sheet Formula

I am using a countif formula on my summary sheet to could true/falses based on the grid which is using a vlookup to another sheet to update the project. However, this formula in the summary sheet is running first and the reports are not accurate. When I refresh the project I can see that the summary sheet takes a couple of seconds to update.

I have this running on another project perfectly, is there a way to combat this, or do I need to rethink my method.

Formulas:

Summary Sheet

=SUM(COUNTIFS(test:test, true), COUNTIF([Confirmed Delivery]:[Confirmed Delivery], true))

Checkbox column formula: (test column in the above formula)

=IFERROR(IF(MATCH(FedEx@row, {lookup}, 0) > 0, true, false), false)

Find more posts tagged with

Accepted answers

All comments

Sean Morgan

Hello @Kevin Wells ,

If possible, please can you provide screenshots of your Reports behavior as well as how the Formula behaves within the Sheet Summary? (Please ensure you hide any sensitive information).

Kindest Regards

Sean

Kevin Wells

Sean,

Thanks for reaching out sorry for the delayed response. This appears to have resolved itself, an internal computer update required a restart and it was causing all sorts of issues with SmartSheet. After restart SmartSheet worked perfectly again.

Kevin

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.