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)

Answers

  • 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
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!