Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Date Counter for Weekly Ontime Rate

Jennifer Ford
Jennifer Ford ✭✭
edited 12/09/19 in Archived 2016 Posts

Hi there!

I need some help coming up with two formulas that will count how many times in the week we hit our projected due date and how many times we are early. I already have a hidden column that looks at the date and calculates the week of the year.

 

I need the fomulas to read something like:

count if 'date completed' is = 'due date' for "W29"

count if 'date completed' is < 'due date' for "W29"

 

Tried to use some of the existing formulas and minipulate, but they did not work for me. The counter will be connected to another sheet what will give me our % ontime rate.

 

Below is a screenshot of all my sheet counters that I have so far.

 

Thank you for looking at this for me!

 

 

KPIScreenshot.jpg

Comments

This discussion has been closed.