IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
Hi, I was trying to use the IF function and it wasn't working so i tried to make it as simple as possible to see what the problem was. Still, it gave me an error even though I just copied and pasted the formula from windows support page so I don't really know what to do.
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.How to keep hyperlink in cells being accessed with IF function across workbooks?
Hello community, I have a workbook that contains a table of insurance industry regulatory filings (called "master filings"). One of the columns provides a link to a PDF of the regulatory filing itself, for people that want to look at the original document. Can anyone help figure out how to carry those links over to a second workbook? Here's a breakdown of the situation: I am building a secondary workbooks that only have entries for regulatory filings that meet certain criteria. For example, I want to build a workbook that only shows the life insurance filings captured in "master filings" and not other types of insurance filings. I successfully used an IF statement to get this data into the second worksheet (basically: if type=life_insurance, insert row,""). The IF statement works for taking the actual text of all desired cells matching the life insurance reg filings into the new worksheet. However, one cell that contains a link to the online PDF of the actual regulatory filing does not send along the link. So in the master workbook, I have a working hyperlink in the word "link", but when it gets carried over to the new workbook, the hyperlink isn't there; only the text for "link" comes along. Does anyone know how to get Excel to bring the hyperlink itself over to the new workbook? Many thanks for any advice! I have attached screenshots showing an example.Help with an IF AND formula
I am having trouble wording a formula that will bring up "Incomplete" if Programming Course and Network Course have even just one "N" and "Complete" if they both have "Y". I included a screenshot to show how close I got but it's still not the correct one. I would greatly appreciate any assistance.2 lists, 1 if
Hi everyone. I'm trying to create such an IF command, that if a certain cell is empty, nothing happens, if it has lets say "1" a certain list prepaired earlier appears, if "2" a different list appears. When attempting to perform the command =IF(A1="";"";IF(A1=1;list1;list2)). I don't have to consider other possibilities other than these 3. When I imput this formula, if A1 is empty, no list appears, which is good, but if I imput an other value (correct for the formula or not) it immediatly creates "list2" Additional question, is it possible, to create a counter of amount of appearences in the program. Lets say the above formula, or corrected by you, works. I'll have a few people listed and because depending on the date and localization that the person appears/will appear, can I set a counter, that will not print, but count the amount of dates "John" or "Sally" appeare in the calendar, even thos, the information is being sent from a list? Thanks
