-
Multiple IF Statements Using "ISDATE"
I have an existing formula that enters text based on two criteria: if a date exists in a column, and if that item was closed prior to the anticipated delivery date. The current formula is: =IF(ISDATE([Closed Date]1), IF([Delivery Date]1 > [Closed Date]1, "Complete", "Fail")) I'd like to add an additional criterion that…
-
Formula for RAG rating based on status and dates
Hi Smartsheet community, I'm after a formula that will produce the different RAG ratings. I'm definining them based on whether they are on schedule and their statuses. Blue is 'Status'="Complete" Red is (open for advisory) 'Status'='Not started' and 'start date' < today and end date is within 14 days OR Status= not started…
-
Issue with task health formula
Hi all, I'm defining a column that will help PM's easily see which rows in a very large timeline to focus on (Health is the column name). I typed this directly into SmartSheet to avoid any invisible characters. I've looked at it many times and can't see an issue with the formula. Can anyone else see it? Based on columns…
-
help with formula IFERROR
Hi I need help with the below formula please as getting errors I would like to count requests submitted from Janaury - December in 2024 and 2025 from a specific region eg, europe, Asia etc
-
I need a modification on an IF THEN statmenet
I have a column in my grid that generates the Task number automatically for Level 2 and all of the children below it. IE if I choose the drop down "Task 1" for a row that is level 2 then that row and all children of that row will show "Task 2". I did that using this formula: =IF(Level@row = 2, LEFT([Task #]@row, 7),…
-
IF Formula
Hi I would like help on a formula to score time criticality. Ive tried the below but its coming up with errors. I also would like to add a formula that if there are any negative numbers such as -201 then this would show as "10" Formula i used below but not working =IF([Time Criticality]@row <= 30, "10", IF([Time…
-
Hi team, may I have help with the IF formula below?
=IF([Rank]@row = "1", [Request Date]@row + 5,""), IF([Rank]@row = "2", [Request Date]@row + 7,""), IF([Rank]@row = "3", [Request Date]@row + 9,""), IF([Rank]@row = "4", [Request Date]@row + 11,""), IF([Rank]@row = "#NO MATCH", [Request Date]@row + 11, ""))))) I'm trying to add an IF formula based on the rank column and…
-
IF AND Formula with Multiple Criteria
Hi there, I've searched so many threads and tried parsing together how this would work for my scenario but I keep getting an invalid argument. I have a column for "Status" and I want to incorporate a formula to auto select the status based on other cell criteria: Open: If "Date Shipped to Supplier" is blank At Supplier: If…
-
How to use IF/AND/CONTAINS formulas with multiple sheets
Hello, I am having a bit of difficulty expanding an IF formula to include a value that is in another column. Let me give an example https://app.smartsheet.com/workspaces/GJqhP3jxmV78WQfw4mc3c6PXH3WqPJcjM2c3Frh1 In this mock workspace I have created basically what I'm doing and what I would like to happen. (all names and ID…
-
Adding One More Criteria to Working COLLECT Formula
I have a working formula where I need to add one more criteria to a COLLECT function but can't seem to get it working. Here is the current working formula: =MEDIAN(COLLECT({Platform Test - Submit Status to Intake Date}, {Platform Test - Quote Testing Completed Date}, AND(@cell >= $[Start Date]$1, @cell <= $[End Date]$1),…