- adding an unmarked check box only if its a grandchild row
i need to add checkboxes to the grandchildren rows. how can i do this without making it look so messy? i created a workaround with helper column but it looks messy and its time consuming.
- Merged: Move certain columns only to a new sheet
This discussion has been merged.
- Moving certain columns to a new sheet based on criteria
Is it possible to move only certain columns to a new sheet based on certain criteria? For instance, when an employee is terminated, I only want to move his name, termination date, and department to the offboarding tasks sheet rather than moving the entire row with so much information not needed for this sheet. I realize…
- Report not refreshing daily
I created a report from one of my sheets and the report was inaccurate when my boss looked at it at 10:00am MT this morning. He called me so I got on around 10:38 and hit refresh on my end and then the report was accurate. Why is this? All the data on the actual smartsheet was showing correct for him but the report itself…
- Pulling in data based on certain criteria in another column
你好,我想pull in all the employee names that work in sales from the Employee Database sheet to a new sheet but my formula is only pulling in one name. The sheet below is the sheet where all the data is. =INDEX(COLLECT({employee name}, {department}, "sales"), 1)
- SUMIF FORMUAL WONT WORK IN COLUMN THAT IS CONVERTED TO A FORMULA
I am trying to sum the net sales for the current month in my "Daily Sales Activity" sheet IF my helper column says "YES" (this is the current month) but I keep getting INVALID DATA TYPE. My formula is =SUMIF([CURRENT MONTH HELPER 2]:[CURRENT MONTH HELPER 2], "YES", [Net Sales]:[Net Sales]) i think its because the rest of…
- PTO ACCURAL TO REFRESH ON JAN 1ST
Has anyone figured out how to refresh the pto accrual on Jan 1st? This is my formula that works fine in this current year: =IF([EMPLOYMENT TYPE]@row = "FULL-TIME", [WEEKS WORKED FROM START MONTH AND DAY TO DATE]@row * 1.66, 0)
- Book Library with Form
We have several books in our store that we lend out for employees to read and I need a way to easily keep track of requests and know if they are in use or available. Below are screenshots of what I am thinking but I am unable to figure out what type of formula I will need to know when a submission is made to request a…
- Index Match (No Match)
Im pulling in information from another sheet to the sheet in the image below and I cannot figure out how to only make the date show up when there is a match. I do not want "No Match" to appear. =INDEX({picked up}, MATCH([Ticket #]@row, {ticket number}, 0))
- Need PTO available IF full-time & ....
I am having trouble creating a formula to show pto available for each employee. There are two IFs and each IF has an AND. below is what i came up with and its not working although the IF(AND works when i only use one IF. Hope that makes sense. Ex: if an employee has worked for less than 1 year and they are full time, they…