-
RYG Formula based on Due Date and Percentage complete
I am struggling to create a formula for the RYG symbols. I would like to base it off percentage complete and due date. What I am looking for is: Red = Due date <2 days less than .90 and anything past due Yellow = Due date < 4 days less than .50 All other green
-
Formula for Imported Data
All, Im importing data into smartsheet from excel and there is a lot of extra information in the file. How do i copy select columns over into another sheet? I will be doing this on a weekly bases can i create a "raw import sheet" that will automatically copy the information over to my preferred sheet? I will be deleting…
-
# of occurrences formula
I want to show how many times in the past six months that a supplier has had a complaint issued against them. This is the formula I am using but it returns all zero's. =IF(Supplier@row = "", "", COUNTIFS(Supplier:Supplier, Supplier@row, [Date Submitted (Created Date)]:[Date Submitted (Created Date)], ">=" + TODAY(-180)))…
-
Total Sum not calculating in Smartsheet correctly
Hello SmartSheet Community. I have created a report with various categories and totals. I wanted to capture certain categories and their totals however the totals are not calculating correctly. I would have to copy the totals, paste them to an excel blank sheet and AutoSum there. Can someone see what I am doing wrong?
-
Index, Match formula returning some, not all values
Formula was flowing correctly, but some change seems to have partially broken the pull but I can't figure out what/how. "Project" column dropdown is linked to a Master sheet. Budget Owner column contains the below formula which should look for the cell value in the Project/Cost Center/IO column within the P+CC+IO column of…
-
Match / Sumifs formula
Hello! I am looking for a formula to match the entry in sheet 1 to the entry in a sheet 2, then sum a column in another sheet 2. Would a match or vlookup formula work best? 1 - Match Primary, Tower and Blade columns in sheet 1 to Site Name, Turbine Number and Blade Number Sheet 2 2) Return sum in Travel Hours column from…
-
Extracting Multiple Data from one cell into multiple cells - same row
I have a smartsheet where I'd like to extract data from the LIST ALL occupants column and place them into Occupant 1, Occupant 2, etc. out to 13. I have this working for columns 1 and 2, but then it repeats, even though I change the +# in increments of 1… and if there are no additional names, I'd like it to be blank.…
-
Count projects completed in a date range
Hello, I am looking to create a summary formula that calculates the projects completed within a given month. From the screenshot, I need a formula that evaluated the 'Status = Posted Live' AND the Actual Completion Date within March 2026. I've been playing with the CountIf formula, but I can't get it to work! Any ideas?
-
Setting up a metric sheet to calculate the YTD sum, but not show data in future months
I’m trying to set up a metrics sheet that will feed into a dashboard to show a rolling total over time, but I don’t want future months to display any data. For example, a user will enter values in the right-hand column, and I have a formula that calculates a rolling total in the green column. The green column is what I…
-
Count IF(s) Formula Help
I need help with a formula in Smartsheet. I'm trying to count occurrences of specific values in my Issue Type column, but I have Allow Multiple Values Per Cell enabled, which is causing issues with the COUNTIF/COUNTIFS formula. For example, my expected results would be: Incorrect Product (6) Missing Parts (2) Defective…