Formular to show tasks marked 100% in past 7 days, 30 days by user

edited 12/09/19 in Formulas and Functions

Hello, I am trying to add formular to sheets to show the tasks that have been marked 100% for each user in a certain time period, ie past 7 days, or 30 days etc. This data will be shown in a widget on our report page for team dashboard. 

Glad of help


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!