This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello,
I’m trying to create a bill spreadsheet for myself. I have a column for “Next Due”. I want a field to be labeled what pay period that bill falls into. I get paid bi weekly, so how would be the best way to do this?
Basically I want to be able t...
Hello,
I have a date field and a checkbox field. Can I write a formula that says if there is a date in the date field, check the box in the other field?
Eg “Date Commission Paid” has a date, so “Commission Paid” is ticked?
Hello, I’m creating a spreadsheet which has multiple tables for different events (event 1, 2, 3, 4) we put on, and within those tables is dollar amounts. I then have a separate table with rows for each event, and I want the table to calculate the tot...
Hello, I’m trying to do a formula that calculates commision due. I have the commission field, and I also have a ‘commision paid’ checkbox field.
Basically I want the commission owing field to calculate the commission if the paid field isn’t ticked ye...
You’re awesome, thanks for your reply! It seems to mostly be working, except:
Just looking at this most recent pay period 13 March - 27 March.
NIB is due 23rd March, Hello Fresh due 19th March. They’re put into different pay periods with that formula...
