A Timesheet With InvoiceA 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
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

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("")))