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.
Formula that updates a cell in another column
Does anyone knowif there is a way to have a formula in one cell update a cell in another column? Currently I have a formula for a check box column (Task Complete Column) that checks the % Complete and if the task is 100% complete the check box is checked automatically.
eg: (=if ([% Complete]4,1,1,0) This updates the check box for row 4 "Done" column.
If the user manually clicks the "Done" check box, I would like to update the % Complete to 100%.
If you place a formula in the % Complete cell and someone enters 25%, the formula is wiped out.
I thought I could have a dummy, hidden column that checks the Done check box and if it is checked I would update the % Complete from the dummy column. I have not been able to find a way to do this. I can do this in the dummy column but, it doesn't update the % Complete and the task doesn't show as complete. Any suggestions or am I making this too complicated? Right now I just told the users to update the % Complete and all is well. I just keep thinking that there should be a way to do this. I have asked Support but, they have not responded with a solution yet.
Thanks for any suggestions...