Question

I looked over the page for IfStatements but don't see what I was hoping to find.

Is there a way to say

   If (exists SomeTopic) then
     do something, e.g. INCLUDE it or TOC or show a link...
  else
     something else

Environment

-- VickiBrown - 11 Apr 2007

Answer

If you answer a question - or have a question you asked answered by someone - please remember to edit the page and set the status to answered. The status is in a drop-down list below the edit box.

It should be possible to do the IfStatements with a VarIF.

Alternatively, use the SpreadSheetPlugin#FuncIF formula. For example:
%CALC{$IF($EXISTS(WeeklyReport), $NOP(%)INCLUDE{WeeklyReport}$NOP(%), Weekly report is currently not available)}%

-- PeterThoeny - 13 Apr 2007

You cannot use IF for this.

-- ArthurClemens - 13 Apr 2007

see bug report 3889

-- VickiBrown - 13 Apr 2007

This is fixed now. Specify a full $EXISTS(Web.Topic), or upgrade to the latest SpreadSheetPlugin.

-- PeterThoeny - 15 Apr 2007