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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!