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

Project Intake form in one workspace updated the Intake sheet in another workspace
Hope everyone is doing well. I would appreciate any insights you may have. I used the Project Management Template (PMO) to create an new workspace. Did this by saving this folder structure as NEW and called it MS Onboarding Lite. PMO structure: MS Onboarding Lite The first time I used the PMO to create a workspace was for…
Rolling-up information from sheet and reports. Unable to group information.
I am creating a report that pulls data from sheets and one other report. The information rolls up fine from both the sheets and report but it does not allow me to group the information from the report. For example, I want to group by program and then sub-group by sub-project. I keep getting a "Blank" for the group and the…
Need Help with a Formula
I'm trying to create a formula that says if the date in the "due date" column is between 60 and 90 days from today, mark yellow I've tried a few things but can't figure it out. Can anyone help?