Retrieving highest filled in parameter for schedules

[michiel_duinslaeger]

Hello,

In our titleblocks we have an array of parameters called Index1, Index2, Index3 and so forth, the same goes for Date1, Date2, Date3.... Each time we produce an altered plan we fill in the first empty index and it's corresponding date on the sheet when it's sent out.

I'm now working on a sheet schedule for my new template and I wanted to show the current index, so I want to just show the last filled in Index value.

My idea was to use a formula like this

IndexLast =if(Index10, Index10, if(Index9, Index9, if(Index8, Index8, if(...))))

to find the highest filled in Index by going down the numbers down to Index1

But I have no idea where to use the formula and how to plug in the Shared Parameters that are Index1, Index 2... and so forth. They don't show up in the parameters I can use in the template schedule and I don't think I can place it anywhere in the Titleblock family either.

Does anybody have an idea how to handle this? If there's a better way I'm open for it.

[ToanDN · Accepted solution]

You cannot use text parameters to drive formulas.  Use number parameters for date such as 20220502.

[michiel_duinslaeger]

So it won't work then. Index is a letter.

That answers another issue I've been struggling with then, showing a custom scale bar based on the written value in a"Scale" parameter.

[barthbradley]

---

@michiel_duinslaeger wrote:

Hello,

Each time we produce an altered plan we fill in the first empty index and it's corresponding date on the sheet when it's sent out.

---

@michiel_duinslaeger: Why don't use use the Revision Schedule for this?  Seems it would do exactly the same thing.