Explore. Ask. Answer.

or Explore Discussions

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

Kelky01Kelky01
edited 12/09/19 in Formulas and Functions
08/27/18 Edited 12/09/19

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

Tags:

Comments

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    You will need a helper column to have the user input the date it was marked complete as Smartsheet does not have a time stamp for when a specific action is taken other than created and last modified.

     

    From there you can run a report with the criteria that complete is checked and completed date is in the past x days.

    thinkspi.com

Sign In or Register to comment.