Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Invoicing formula, am I on the right track ?

Heath Sanders
edited 12/09/19 in Archived 2017 Posts

When a job is invoiced say on and between Jan 1st till Jan 31st (Invoice Date]:2 then the commissions will be paid the 20th of the following month Feb 20th[Paid Date]:2 Im assuming a nested If statement would be needed for each month? assuming of course. If someone can help get me stated, that would be very helpful. Thank you.


Im guessing it would look something like this .....


=SUMIF([Invoice Date]2,<= 01/01/17,>=31/01/17,[Paid Date]2=20/02/17,IF([Invoice Date]2....and so on.






This discussion has been closed.