Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
I have a spread sheet with a column (with a formula) that counts how many days it took for each project to get from one department to the next. I am trying to figure out a formula to add all those days together but just from a specific month in 2018... I will eventually have to do this for each month for the next couple years. Please help!
This is what I have come up with so far
=SUMIFS([Job Started]6:[Job Started]619, AND(@cell >= DATE(2019, 1, 1), @cell < DATE(2019, 2, 1)), [Days From KAS to Invoicing]6:[Days From KAS to Invoicing]619)
With SUMIFS, you specify the criteria RANGE before the criteria. So your range is [Days From KAS to Invoicing]6:[Days From KAS to Invoicing]619 and your criteria is AND(@cell >= DATE(2019, 1, 1), @cell < DATE(2019, 2, 1)).
Try switching those around and see if that works. If you are looking for a specific month/year combo, you could also use something along the lines of this for your criteria...
AND(MONTH(@cell) = ##, YEAR(@cell) = ##)
Just replaces the #'s with whatever numbers you want. It may be a little easier to update, but that's just a personal preference.
How do I see who submitted a form for a specific sheet?
Hi, I have a Gantt covering 500+ rows of events past and planned. I use it to predict and track values around these events. Using helper columns to identify the current week, I get an email report on a Monday that tells me the upcoming events in the current week (7 days) and their values. Currently if an event spans…
Hi Smartsheet Community, I'm working on an action management system where users create sub-actions through a Smartsheet Form. The requirement is simple: a sub-action's due date must be earlier than or equal to its parent action's due date. For example, if the parent action is due on June 30, 2027, users should not be able…
