8

Any ideas on constructing more user-proof formulae? 

 

I'm having trouble with users inserting rows in a sheet versus appending new rows at the bottom.  Locking rows doesn't prevent an insert (would be nice if a non-admin user couldn't insert when adjacent rows are locked).

 

I've used the following

3

I have a head scratcher here, thanks in advance for any help that anyone may have. 

 

My scenario is this, I have project plans that have two sets of dates, one is estimated dates and the other is the actual dates on the project tasks. In my project settings the estimated dates are linked to the

2

Hi Smartsheet -

 

I recently created a series of report in smartsheets that pull specific pieces of information for departments so that managers can see their respective things and provide updates. However, unlike a regular sheet, where you can lock certain columns so as to prevent users from being