How to create a formula that calculates a column called "teach days" for monthly data.

Answers
-
@Heather White do you wan to use the sum formula in a dashboard or metric? Maybe you could also rty to use a report .
If my comment helps you, I appreciate a 💡
Kind regards
Event: Strategies for Successful Adaption
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
https://www.eventbrite.de/e/driving-change-with-smartsheet-strategies-for-successful-adoption-tickets-1047813557557?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurlWe offer Licenses - Training - Solution Engineering
🔴Certified Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
-
i currently have it in a sheet that i take that number and put in an excel document because i cannot figure out how to create a chart with all the data i need to display.
For all the tasks i have listed from Jan to December, i only want to pull monthly data for 11 people, separately for types of work they are doing.
-
@Heather White why you put into excel? Are you not trained ?
I have the feeling you could make it easier … for example with reports or an metric sheet
But here is a formula you can try …=SUMIFS({ATC Instructor Schedule 2025 Teach Days},
{ATC Instructor Schedule 2025 Type}, "Teach",
{ATC Instructor Schedule 2025 Assigned to}, Contacts@row,
{ATC Instructor Schedule 2025 Date}, >=DATE(2024, 9, 1),
{ATC Instructor Schedule 2025 Date}, <=DATE(2024, 9, 30))If my comment helps you, I appreciate a 💡
Kind regards
Event: Strategies for Successful Adaption
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
https://www.eventbrite.de/e/driving-change-with-smartsheet-strategies-for-successful-adoption-tickets-1047813557557?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurlWe offer Licenses - Training - Solution Engineering
🔴Certified Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
-
No, no training, all self teachings with smartsheets. When i called support, they were unable to tell me how to get the visual i needed in a chart through smart sheet, so ive managed to get the calculation in smart sheet, however i have to put into an excel so i can create a chart that i cannot get from smartsheets.
I tried the formula adding the dates as above, but it's not calculating correctly.
=SUMIFS({ATC Instructor Schedule 2025 Range 4}, {ATC Instructor Schedule 2025 Range 2}, Contacts@row, {ATC Instructor Schedule 2025 Range 5}, [2024 Total Days]@row, {2025 Instructor Schedule Range 1}, >=DATE(2025, 2, 1), {2025 Instructor Schedule Range 2}, <=DATE(2025, 2, 28))
-
@Heather White can you share the sheet ? Its easier, faster to find the problem .
If my comment helps you, I appreciate a 💡
Kind regards
Event: Strategies for Successful Adaption
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
https://www.eventbrite.de/e/driving-change-with-smartsheet-strategies-for-successful-adoption-tickets-1047813557557?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurlWe offer Licenses - Training - Solution Engineering
🔴Certified Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
-
what email to share to?
-
nico.roepnack@lighthouseconsultings.com
If my comment helps you, I appreciate a 💡
Kind regards
Event: Strategies for Successful Adaption
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
https://www.eventbrite.de/e/driving-change-with-smartsheet-strategies-for-successful-adoption-tickets-1047813557557?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurlWe offer Licenses - Training - Solution Engineering
🔴Certified Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!