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 text box is blank, show “Input Required” error, if txt box is not empty, make popup visible
Hello I have a text box where a user must enter a number (price). There are also popup object grouped together. When a user clicks the submit button, the text box should be controlled if there a value there that 1. is greater than a value in a SharePoint list column, and 2, if the column in the SharePoint list is blank, it should check that the value in the text box is greater than 0. If it meets this Criteria, the popup (which contains all the pop up objects) should be displayed (visible). I’m pretty new to this and I went through a few if statemetns and tried to incorporate the update context unfortunately without success. Thank you so much in advance for ur assistance
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.