Welcome!

Due Date dependent on predecessor AND allocation %

Hi,

I'm trying to get end dates to change based on estimated hours AND allocation %.

Is that possible? How do you do this?

Thanks!

the formula

=date1 + 1

will add a single day to the date in the date column first row.

knowing that dates can be manipulated this way, we can use a simple statement to adjust the date

=date1 + ([Estimated Hours]1*Value + [Alocation %]1*Value)

If you want to make it more complex you can use an if statement to make a faux variable to adjust the date based on criteria.

=date1 + if([Allocation %]1 > 50%, [Stock Project Duration]1 * 1.25)

Or something like that.

Getting the Triggered by at least 5 other workflows but nothing is daisy chained
Hello, I'm seeing this error for the first time as I expand some capability in an existing workflow. Here's how this section with the error works. Scenario: a user puts in a request on the form with a check box indicating they will later upload the required file attachment. Automation sends a request for Approval with…
Re assign task midway thru
I have a task that started in Sept and ends in Feb. I need to assign it to someone else, but do not want to lose the history of the first employee. How do I do this?
Suddenly receiving multiple emails titled "Your Smartsheet Order has been Activated"
Starting a couple of days ago, I started getting 2 or more emails a day about my account being activated. I have a monthly subscription but have never received this type of email from Smartsheet. The email looks legitimate - the sender is "reply_to@Smartsheet .com" - except for maybe the greeting, which is "Dear Customer".…