Need help with a report formula

Question

Hello Everyone,&nbsp;&nbsp;I am still pretty new to quick base when it comes to certain functions and I need assistance in the formula set up for a report.&nbsp; Basically what im trying to do it I have our sales team activity tracker for the week and for the day so I would like to have the reports reset after their allotted time.Can any one shed some light on how to create the formula for the following:&nbsp;Reset at end of day&nbsp;Reset at end of week&nbsp;Thank you for the assistance------------------------------Addam ODell------------------------------

markshnier__you · Answer

Can you explain more details about what do you mean by reset? Do you mean you just want reports of what activity was done for the current day? If that is the case then make a report where the shelter on date created is today.

If you want another report of activities during the Current week, then you can make another report where the filter is where date created is during the current week.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

evanmartinez · Answer

Hi Addam,I agree with Mark if what you are looking to do is have only records from the current day or current week show up in a report instead of a formula you typically want to use the Filters option when customizing the report. When you filter on a date field you have options for the current day, week, month, etc. So you can easily create reports based off of the date in your fields or if you are wanting to identify any record that was edited by someone you can also use the Date Modified field since that updates whenever someone works no a record and saves changes.------------------------------Evan MartinezCommunity Marketing ManagerQuick Base------------------------------

addamodell · Answer

Thanks this worked!!------------------------------Addam ODell------------------------------

Forum Discussion

Need help with a report formula

Related Content

Merging 2 Fields into a Formula-Text Field for Reporting Purposes

Formula Url Buttons

Summary Reports

URL formula -API_RunImport

Percent Formula Help