Sign in to join the conversation:
I am trying to count anything that is due this week. I have a due date column in my smartsheet, but what is the best way to count this information?
Try a formula like this where I assume your date column is called DueDate -
=COUNTIFS([DueDate]1:[DueDate]99,">="&[WeekDate]$1,[DueDate]1:[DueDate]99,"<="&[Weekdate]$2)
Populate 2 cells in the sheet in a column called Weekdate with the "start of the week" and "end of the week" dates.
Hope this helps.
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
I have a column named Territory, where I am trying to write a formula to populate it when names are chosen from an adjacent drop-down list column called Employee Attendee. If more than one name is selected from the Employee column, I would like their respective territories to populate in the Territory field, separated by a…
Hello, I am trying to find the average audit score for a range of percentages between two dates. There are divider rows for organization by month. I have been trying to utilize the following formula but continue to get #DIVIDE BY ZERO for an answer: =AVG(COLLECT([Audit Score]:[Audit Score], [Date of Chat]:[Date of Chat],…
