Summary formula vs Column formula: Incompatability issue?
I have several grid sheets that have SUMIF summary formulas running.
I’m working on a new sheet that requires I split the date & time that are included in one column. Summary formulas I would ordinarily run on the Program Start Date no longer work. Am I correct in assuming the summary formula will not operate on a column that includes a column formula? Is there a work around for this?
Best Answer

You are correct that it will not work on a column formula, because your summary formula is being replaced by your column formula. When I need summaries for columns where I have a column formula, I either put a formula in the sheet summary, or I create a separate crossreference metric sheet to gather the data. If your data is indented to have Parents/Children, there are some options there for a column type formula with summary. Hope this helps.
Answers

You are correct that it will not work on a column formula, because your summary formula is being replaced by your column formula. When I need summaries for columns where I have a column formula, I either put a formula in the sheet summary, or I create a separate crossreference metric sheet to gather the data. If your data is indented to have Parents/Children, there are some options there for a column type formula with summary. Hope this helps.

Great insight! Thank you so much!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 200 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!