Sign in to join the conversation:
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
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.
Hello! I am attempting to create a gift card inventory log and a transaction log. I created a master sheet to house the general inventory. I also created a transaction log. My goal is for them to talk to each. The master sheet will house all of the gift card information like, the serial numbers, description/store, value,…
I want to lookup a specific start date based on 2 criteria: (1) Workset; (2) Week # in the main sheet. I have a separate sheet that contains the dates I am pulling in. I tried using INDEX(COLLECT and I can't seem to get it to work. Data Set: Workset Week # A, B, C, D 1-12 Example: If you have Workset A and Week # 5 the…
Hi How do i set created Date column to only show entries from line 24 downwards?
