-
#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β¦
-
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
-
Multiple AND
This is my formula: =IF(AND([Scheduled Complete]6 < TODAY(), [Document Added]6 = 0, Complete6 = 0), 1, 0) Not sure what i'm missing but as soon I check the box for document added it clearsΒ my flag. I don't want the flag to clearΒ until all three criteria are met.
-
COUNTIFS returning different values in Excel versus Smartsheet
I am having some trouble with creating COUNTIFS functions that reference cells across multiple sheets. I'm trying to create an active dashboard that will reflect performance data over the following periods: month, quarter, year. I want the COUNTIFS function to reflect the number of rows that meet the following criteria:β¦
-
IF(FIND Function with OR
I am trying to build a formula that searches in a column for a certain word using the IF(FIND formula but I would like to add in an OR to that. So I would like to use this function:Β =IF(FIND("Design", [Project Description]4) > 0, [Estimated Hours:]4, "") which works great, but add in other words such as Graphics to it. Soβ¦