Page 193 - Customize-Project-Plan-by-tailoring-Smartsheet

Customize your Project Plan
   
by tailoring Smartsheet

58.1.6. Use of #-sign in a Sheet Summary Field Report

Here still another special feature in relation to this "Sheet Summary" subject. If we have "Sheet Sum-
mary fields", e.g., "Rating", and we want in a formula to refer to another "Sheet Summary field", then
we simply enter a hash sign (# sign) right after the field name. E.g., [Feasibility Study]#, since this is
alike to the @row-sign, which refers to a certain row, e.g. [Due Date]@.

In our sample here we have a new Sheet Summary field called "Rating". The criterion in the formula
is, that everything less than 2 is then considered as "small", and everything greater than 2 is considered
as "large".

We are going to use this formula there: =IF([Feasibility Study]# < 2, "small", "large")

It is important to understand that if we want to refer to a "Sheet Summary field" in a formula, but we
do not address a "standard" field name (e.g., [Net Duration Hours], ...) there, then we use this #-tag.

© Hans Porzel, 10/2025 | CAPM® (PMI), PSM I® (Scrum.org), Smartsheet Prod. Cert® 2020 Page 193 / 209 pages