-
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…
-
Finding and returning values in a range of cells
Hi all, I'm having a lot of trouble joining cells that contain a certain value (because there is no contain function). I have a range of cells that are all in a single row, and I'm trying to collect all of the cells that contain a certain value, and join them together. For example, say I had a row with 4 columns that say…
-
Pivot Sheet & formulas
HI, I've used pivot sheet to gather required information to show up in a sheet. I've attached a clip of the final result which works great except for the fact that I have formulas in some cells. When a new row is created, the formulas in the cells from above don't copy into the new cells. Can someone help me out. thanks!
-
Auto change a cell based on a checkbox in a different cell (all in the same row though) or change in
I created a pretty intense sheet to keep track on invoices and receipts. I have an "Action" column that is a drop down column. Here are a few of those "Actions" Request Sponsorship Submit Sponsorship Request Invoice Call to pay with CC Call back to pay Submit Check Request Follow-Up Check Approval Mail Check Out Request…
