Forum Discussion
combining ISBLANK with IF/ELSE
Good day all! The below code is for a calculated column. At first, I wanted the column to check another set of columns, each with their own 'stage' and do basically a 'DATEDIFF' on them. That w...
davyjones Are you saving data to this list manually or using Power apps (customized form or canvas app)?
If using Power apps, there might be some issue with it saving default value for column as '12/31/2001'.
Try creating a new list in same site for testing and try using formula like:
=IF(ISBLANK([DateColumn]), "Blank", "With Date")
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
ganeshsanap I am indeed using a Power App to populate the columns. The issue seems to be that the data was migrated over from another tool, and thus did not have values in each of the '(stage)_initiated' columns. I am thinking that I would have to modify the code to look at EVERY one of those stages and filter out those that are blank, because simply looking to the 'requeststate' column might not work.
As for your current suggestion, I am not following what you are asking to do. can you please reiterate?
thank you!
As for your current suggestion, I am not following what you are asking to do. can you please reiterate?
thank you!