A Timesheet With Invoice

A Timesheet With Invoice

Master Tag
Productivity
Created
Jul 24, 2021 03:09 AM
Usage
toNumber
empty
Web Tags
Database
Planning
Layout
Formula
Alternatives
Cover

Donate

 
Insert all projects and client info here.
Projects
Hours Worked
Project
Hourly Rate
Flat Rate
Client
To Invoice
Done
Archive
Final Invoice
$29.00
Client A
Done
Archive
$29.00
Client C
Done
Archive
$34.00
Client D
Done
Archive
$1,600.00
Client B
Done
Archive
Record tasks, how long to each session was, and an invoice suggestion will appear. Hours between the end and start time always round up. (ex. 4.2 hours = 5)
Timesheet
Hours
Task
Project
Start Time
End Time
Rate
Invoice
Archive

Invoice Formula (Timesheet)

if(not empty(prop("End Time")), prop("Hours") * toNumber(prop("Rate")), toNumber(""))

Final Invoice Formula (Projects)

if(not empty(prop("To Invoice")) and prop("Done"), prop("To Invoice"), if(prop("Done"), prop("Flat Rate"), toNumber("")))