How to extract monthly cost totals from a Gantt format?
I'm trying to do two things;
- Create a dynamic cost plan where I can schedule costs on a Gantt format, ideally being able to drag cost items around rather than inputting specific dates.
- Create a sheet that totals the cost for each month from the cost plan.
I've been searching through COUNTIF guidance but i'm struggling to get started. Any pointers would be appreciated.
Answers
-
Hi @bacon_jam If you are trying to get cost totals, I guess a SUMIF or SUMIFS formula would be better suited than a COUNTIF. Try the formula for the desired range and let me know if this works.
Thanks,
Ipshita
Ipshita Mukherjee
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!