Can you skip a row and still use Column formulas?
Hi! I've got this sheet where all columns use the same formula except for the first row which is a kind of "header" and is a text row, if a use column formulas that text is erased, I was wondering if there's a way to use column formula and skip that row. The formula I'm using is =SUM(CHILDREN()) but every time a create a new parent row the formula disappears.
Maybe the formula needs to include from which row to which row it applies to, I'm not sure.
Thank you for the help.
Answers
-
I hope you're well and safe!
You can add another part to the formula, so it first checks if it's that row with the header, and if it is, it will show the header's name.
Make sense?
Would that work/help?
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andrée,
I'm sorry for the late reply, but no it doesn't really make sense, can you perhaps show me?
-
@Andrée Starå How to check if it's that row with the header if the formula has to be in that row for it to be a column formula?
-
I am also looking for a way to skip the first row using a column formula, in my case, using =[Column6]@row - INDEX([Column6]:[Column6], [Entry Number]@row - 1) - this formula will not work in row 1 I am assuming because there is no value to calculate with so I was thinking if there is a way to possibly wrap my formula in an IF statement to exclude row =1
Thank You,
Jackie
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!