Skip to main content
Version: Streamsheets 2.4

SETPHASE

Puts the Text into the target cell, if the condition is true.

Syntax

=SETPHASE(Condition, Text, TargetCell [, OverwriteFormula])

Arguments

NameDescription
ConditionCondition to check for action.
TextText to copy to the target cell, if condition equals TRUE.
TargetCellCell to put text into.
OverwriteFormulaOptional. Set to TRUE will overwrite cell formula. Defaults to FALSE.

Return Value

Depends on condition. TRUE or FALSE

Example

FunctionResultComment
=SETPHASE(21, "Test", B1)TRUEWill put text "Test" in cell B1, as 2 is always larger than 1.
=SETPHASE(21, "Test", B1, TRUE)TRUESame as before, but overwrites possible cell formula so that "Test" is returned on subsequent App steps