Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

% allocation

Bill Brandt

Bill Brandt ✭✭✭✭✭

03/16/16 edited 12/09/19 in Archived 2016 Posts

Is there a way to get %allocation to be set to zero for people once a "completed" checkbox is checked?

0 ·

Comments

J. Craig Williams ✭✭✭✭✭✭

03/16/16

Not if the Dependencies are set.
Smartsheet prevents adding formulas to columns that are used in Project Settings.
I hope they fix that, because it is annoying. It is only a feature for the date fields and even that is questionable.

Craig

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Changing a 'Form' Name
I think the fastest way to update a 'sheet' was to create a template so other departments could use the same sheet design and then the attached 'form'. When I saved the new sheet from the 'template' the 'sheet' adjusted the name but the child forms held on to the old name. While I could adjust the 'form' name in the form…
Forumula help to extra characters from a cell
Morning I am hoping someone has an idea how I can achieve the following I have a barcode which is formatted like this when scanned into Smartsheet (01)00843997014755(11)240401(21)700040293 What I need for example is when the barcode is scanned into lets say cell A, then automatically cell B,C and D will extra data from…
Index Collect partially working
I am trying to validate information using Index Collect function. It works when I look at the school's name, but when I add the 2nd criteria for the school district, I get the #Incorrect Argument Set error. SCID=the ID number SN is school Name in the criterion range DN is the district name in the criterion range…