The Community will be undergoing maintenance from Friday February 21 - Friday, February 29 and will be "read only" during this time. To learn more, check out our Announcements blog post.
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...