Fill up values: Multi Row formula tool does not work?
- 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
I am trying to fill up the Site Name column however the formula is not working as it is supposed to.
Formula:
IF ISNULL([Site Name])
THEN [Row-1:Site Name]
ELSE [Site Name]
ENDIF
What am I doing wrong?
Please find example workflow attached.
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I think we need to do a sorting first, to bring the non-null value for site name to top, then the multirow formula will work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yep, that works however why would the fill up formula not work?
What you have provided is a fill down solution and I have a use case for a fill up.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @HW1
Fill up wont work because the execution is always top to down. Hence you need to add a record id tool reverse the order so that you can perform Fill down.
Hope this helps 🙂