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...
ganeshsanap Thank you for your suggestion! The issue is not the return type, however. I would like a whole number answer for 'how many days have passed' for that formula.
My issue is when the formula encounters a blank column, it defaults to the '12/31/2001' number and results in a huge number for the end. I would like to just have the answer of 'N/A', but it doesnt seem to want to pick that up. Your formula seems to be just like mine, so I wonder why...
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!
