Hi I have a relatively straightforward if statement and it works, but not always. This is my formula and it works, =IF(COUNT(ANCESTORS()) = 3, PARENT(Responsible@row), "nope") however if I replace "nope" with other types of values, the whole thing stops working, including the value if true .. e.g. =IF(COUNT(ANCESTORS()) =…
Was just showcasing a smartsheet to some work colleagues and while we were sharing our screen about 5 lines deleted. We had clicked sort on a column and when the screen refreshed, they were gone. I have checked the activity history and nothing is showing as lines being deleted. its really weird.
你好Brains trust, I have added a checkbox column "Not Applicable to this Plan" to a template project plan. I want the task to stay in the list so that there is a clear indication that this task was considered and then a decision made that it was not relevant. But I want the task ignored in terms of % progress etc. When I…
