-
Need Help! RYG to update if Status = Completed OR % Complete = 100%
Not sure what i'm doing wrong here. I want the RYG column to show green if the status is "completed" OR if the % complete is 1. Please assist. =IF(OR(Status@row = "Completed", [% Complete]@row = 1), "Green", IF([End Date]@row - [Baseline Estimated Finish]@row > 2, "Red", IF([End Date]@row - [Baseline Estimated Finish]@row…
-
#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:…
