Cat_Crawford - profile

Cat_Crawford · Nov 08, 2022

Surely this is an easy formula, but I just can’t get my brain to bend this way: I am using Airtable for my timesheet for my employees. I would like to improve upon my existing “Total Hours” formula by showing “Total Hours by task” , and each task is ...

Cat_Crawford · Jun 27, 2021

I’m new to Airtable (and totally obsessed) and I know enough to be dangerous. I’m certain there is an automated/quick way to rollup data from another table based on the criteria in one field… but I can.not.figure.it.out. Table one has financial data ...

Cat_Crawford · Nov 09, 2022

Adam_TheTimeSavingCo: IF( {Task} = "Teaching", DATETIME_DIFF({Time Out},{Time In},‘minutes’) / 60 ) Perfect! Just what I needed. Thank you!

Cat_Crawford · Jul 01, 2021

Thank you, kuovonne! I manually input the week ending date from Table 1 which then generates the Quarter and Year via formula. Does that give you any more information to make this process more automated?

User Statistics

User Activity

Find Date Time difference only IF a certain single select field is selected

Rollup weekly data by Quarter

Re: Find Date Time difference only IF a certain single select field is selected

Re: Rollup weekly data by Quarter