Trending in Formulas and Functions
Help to count data
We have lot of tasks completed on different months on that how to calculate number of tasks completed on specific month for example on Month July 2023 with a condition that value shows Current=YES.
SUMIFS Summary Formula Issue
Good afternoon - I am trying to create a summary formula that sums the values in the range from Shared Inboxes to Metrics if the Date column is between 11/1/23 and 11/30/23. I've created the following formula; however, it's returning #INCORRECT ARGUMENT SET. Any suggestions? Thank you!! =SUMIFS([Shared Inboxes]:Metrics,…
How do I get my sheet to flag automatically
Here is what I'm trying to do: If planned start is in the past and start date is blank...I need late start column to populate a red flag Any idea on this? Is it a workflow or a formula that is needed?