Auto Sum last 6 columns
Hello ~
I'm calculating attendance and want to highlight inactive participants. Currently, I copy and paste =COUNTIF([20 1/6/18]3:[25 02/10/18]3, "P") each week as a new column is added. Is there a formula that will auto add new entires and also limit to the last six columns?
Thanks!
Tags:
Comments
-
Hi Diane,
Smartsheet may autofill this information for you if you add something to a row directly below/above the rows that contain your current formula. There are stipulations to this, see our help center article for more information: https://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I am attempting what I thought was a simple formula to collect a value from the 'Week" column if today's date falls between a Start Date and an End Date. Here's what I have so far which returns an #IN…
- For other sheets, we use formula =IF(ISBLANK([Manually Actioned By]@row), NETWORKDAYS(Created@row, TODAY()), NETWORKDAYS(Created@row, [Manual Actioned Date]@row)) to tell us the turnaround time for th…
- I'm trying to get a running total based on if a certain drop down is used, in this case its value income total value. So if sales income is used multiple times i need the running total?