-
#INVALID OPERATION when dividing
I'm trying to do a count of how many staff have uploaded a particular document. I have who has uploaded the document and how many staff in total, and I want to display that as a percentage on the sheet. Whenever I try to divide # of Staff Uploaded by Total Staff I get #INVALID OPERATION. I've tried it both in formula and…
-
SUMIFS with Cross Sheet Date Ranges?
I'm trying to calculate {Expected Premium} sales by {Producer Code} on an enterprise-wide sales tracker that compares monthly sales metrics per [Producer Code]@row against total renewal opportunity. I've scoured the community for answers but I haven't found anything that answers my question as it regards to cross sheet…
-
Alternative to FLOOR and CEILING functions
Hi! I'm looking for an alternative for the FLOOR and CEILING functions that I use in Excel. For context, I purchase paper, and buy it in skids and fill the remaining balance in smaller packages. In Excel, I use a formula that references a lookup table to tell me how many sheets of paper come in a skid and how many come in…
-
Formula to identify number of parent rows with a specific status (excludes child rows)
Hello, I'm quite new to smart sheets and am having trouble parsing out this particular formula I need to make for a work metrics sheet. Essentially our spreadsheet is comprised of many parent rows with associated childrens rows. The parent row has a column called "Status" which details where the account associated with the…
-
IF / THEN Formula help
Hello, I am new to Smartsheets and i am trying to do the following. I have a column (column 1) which is a text cell and a second column (column 2) which is date format. I am trying to say that if column 1 is not empty then return the month value of the date in column 2. My formula currently is as follows, i believe i have…
-
Counting Check Boxes Across Multiple Sheets
I have the same sheet for 7 different individuals that has 12 columns and 38 rows...each cell is a check box. I want to create the same sheet that shows a count of each sheet per cell. So, how many of the 7 sheets selected row 1, column 2? How many selected row 1, column 3? And so on. I have seen numerous discussions about…
-
Is there a way to count parents of a task?
-
Formula to calculate category totals
I have several expense categories in a dropdown list. I am looking for a formula to calculate totals when a given category is selected. I need it search the column and total all of the amounts listed as "other", "airfare", etc... thanks, SGF