Auto add solved date on list with IF function, equal to other column's value
Hi Guys! I am struggling with the following, I have a "solved date" column, where I'd like to add the solved automatically, if status equals to Closed status then it should be the last modified date (it's another columns value), for anything other status should be today's date. I modeled the logic in excel, it works there, but when I translate to Sharepoint it says error, I just can't figure out why it is not working. Does anyone has any idea? I have come to this formula: =IF([Status]="10. Closed";[Modified];IF([Status]="12. Closed";[Modified];TODAY())) Thanks!!!
IF Formula not displaying in modern mode
Hi Team I created a Calculated (calculation based on other columns) column with a simple IF formula =IF([column1]<=[column2],"UnderBudget","OverBudget") but it is not displaying in modern mode, only in classic mode? any quick fix? screenshot attached with developer tool errors showing in modern mode.