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.
Formatting With a Range of Dates
I need to create a formula that looks at two different date fields and produces the result as a check (or no check) in a checkbox field.
The two columns are: "Date Requested" and "Date Received." The expectation is that the "Date Received" will be 4-6 weeks after the "Date Requested." So basically, I need the box checked if the received date is less than 6 weeks from the requested date. Also, the box needs to remain unchecked if the "Date Received" field is blank.
Ultimately, we are trying to create a "scorecard" to measure the efficiency of our various suppliers. We will then need to filter by the supplier and calculate, by percentage, how well they are meeting expected delivery times.
Any takers? Any help is greatly appreciated.