Hi all!
I need some assistance in creating a formula that links a column in my first sheet (Health Records) to a formula that is in another sheet. In this second sheet I hope to use the =IF(BLANK) function to display whether these records are "Complete" or if left blank in sheet one, "Incomplete". I have tried using the following formulas but found no success.
=IF(ISBLANK([Health Records]), "Cell is blank", "Cell isn't blank")
=IF(ISBLANK([Health Records]), "", "Complete")
Any help or guidance would be greatly appreciated. Thank you.