Adding value in a NULL \ empty cell
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have a Null\empty cell that I want to replace with "Original.Due.Date" (only the first Null line).
Can someone let me know how I can edit only this cell (and not the other Null cells I have down the list)?
Thanks,
Sahar
Solved! Go to Solution.
- Labels:
- Developer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @sahartz
EDIT: Missed the requirement for only the first null cell. @messi007 's solution probably accounts for that way better.
A formula tool and if statement should do the trick. In the formula tool you select the existing corrective action column. The if statement will check if the value for each row is empty (IsEmpty will check for both nulls and empty values), and replace it if that condition is true, otherwise it remains the same.
if isempty([Corrective Actions5])
then [Original.Due.Date]
else [Corrective Actions5]
endif
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks!!!! Your solution is great if I had only 1 line with Null but I have additional Nulls so I cannot use this solution
