-
Count only if Parent
I have a [RowID] column that is populated by this formula =IF(ANCESTORS@row = 0, COUNT($ANCESTORS$1:$ANCESTORS@row, "")) It returns sequential numbers but, I need it to only count if Ancestor = 0 Secondly, I need the result fill format to look like this 0000 (like an auto number) 0001 0002... 0100 0101 0102.. 1000
-
Nested If Formula
Hello, I am trying to create a nested IF formula based on the criteria below. Below is also a screenshot of what I am trying to do: =IF([% Complete]1=0,"Not started" =IF([% Complete]1>=0 and <=1, "On track" <code class="CodeInline">=IF([%Complete)]1=1,"Completed" =IF([%Complete)]1<=1 and Due Date is past,…
-
Archived Community Post: Why am I asked to log in to Smartsheet to use Community?
Hello, I am wondering why I am asked to log into Smartsheet if I have clicked on Help from my Smartsheet window? Shouldn't Smartsheet know I am logged in since I accessed it from my already logged into Smartsheet? Thanks!