AI won't edit this formula

Question

I need help to edit this formula to include only Designations with a Date of Manufacture (this is the column name) greater than 01Jan2025. I keep getting a request to regenerate the question. =COUNTIFS([Days btw Capping & Mfr Release]:[Days btw Capping & Mfr Release], >60, Designation:Designation, <>"PPQ1", Designation:Designation, <>"PPQ2", Designation:Designation, <>"PPQ3", Designation:Designation, <>"PPQ4", Designation:Designation, <>"MDP5", Ancestors:Ancestors, "0")

Ankesh · Accepted Answer

Based on my experience, Smartsheet's built-in AI works best for generating formulas from scratch. It still needs to mature a bit when it comes to editing or extending complex existing formulas. I would recommend using DATE() for the date comparison to avoid any regional format issues. As, Smartsheet is particular about date formats in formulas. See if below works: =COUNTIFS([Days btw Capping & Mfr Release]:[Days btw Capping & Mfr Release], >60, Designation:Designation, <>"PPQ1", Designation:Designation, <>"PPQ2", Designation:Designation, <>"PPQ3", Designation:Designation, <>"PPQ4", Designation:Designation, <>"MDP5", Ancestors:Ancestors, "0", [Date of Manufacture]:[Date of Manufacture], >DATE(2025, 1, 1)) ➡️Make sure the column name matches exactly. HOpe it helps! Thanks Ankesh

Dina B · Accepted Answer

@Ankesh - It worked! Thank you!