Comments
-
This takes care of the first part. =IF(OR([cost recovery]1 = "Blank to Invoice", [cost recovery]1 = "Operation to Invoice"), "No", "")
-
I misread the 'blank' in the original message. the "2" is just the row i used when testing.
-
Hi, try this. =IF(ISBLANK([cost recovery]2), "No", IF([cost recovery]2 = "Operation to Invoice", "No", ""))
-
Thank you! that helped.
-
False alarm, looks like it was user error. Someone forgot to hit 'save' before exiting the sheet.
-
Jim, I think you have to use the =countif function.
-
我有一个相同的问题。喀拉海,would i use the API to accomplish this?
