How to insert Blank row

[RaviPM10]

Hi Team, I've build an workflow however I'm stuck how to insert a blank row above Total Valuation

Condition is if Security column contains "Total Valuation" I wanted to add blank row above it & ensure formatting don't get changed.

[nagakavyasri]

@RaviPM10 Try this:

[RaviPM10]

Thanks @nagakavyasri  this works however is there any option to add a row without referencing "Blank row" file, already my workflow have a multiple reference file.

[nagakavyasri · Accepted solution]

@RaviPM10  'Generate Rows' could be another solution. But since you have a condition to generate blank rows, this is the possibly solution I could think of at the moment.

[flying008 · Accepted solution]

Hi, @RaviPM10 

FYI.

1- Multi-Row Formula: [Ref] = 

IIF(IsEmpty([Security]) && [Row+1:Security] = 'Total Valuation' , 2, 1)

2- Generate Rows: 

RowCount <= [Ref]

3- Multi-Field Formula: for all field

IIF([RowCount] = 2, Null(), [_CurrentField_])

4- Select: Remove unless fields.

[binuacs]

@RaviPM10 another option

[RaviPM10]

Thanks @flying008  its look good

[RaviPM10]

Thanks @binuacs  want to add one more condition what if I want to add row if Quantity cell contains text value, for example Corporate value, State value & ETC.

[binuacs · Accepted solution]

@RaviPM10