Hello
I need to add multiple columns that allows us to input the "on site date", - "Manufacturer Lead time" - "Drawing Approval" = Drawing start Date.
Screenshot as below.
Appreciate any help to solve this issue.
Regards Daniel
Hi Daniel,
Not sure this is what you wanted.
Try something like this.
=[On Site Date]@row- [Manufacturer Lead Time]@row- [Drawing Approval]@row
The same version but with the below changes for your and others convenience.
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Let me know if I misunderstood your need!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hello Andree
thanks for this, doesnt seem to work but this could be down to the column properties.
on site date = Date/time
Manufacturing Lead time = ???
Drawing approval = ???
Drawing start date = Date/time
sorry new to smartsheet and formulas.
When dependencies are enabled only one start date, one finish date, and one duration column can be used. To have multiple durations factored in to a task, you will need to break each part down into a child row of the overall task.
If you are wanting to keep everything in one row, you will need to convert your durations into a number of days and then use those for your calculations.
For example... If your first duration is 2w and your second is 4w, you would need to convert them to 14 and 28 respectively and then use the 14 and 28 to calculate your dates.
Hello Paul
thanks for this, i understood what you are saying so the last paragraph is something i could use, but how would this be reflected in column required and formulas to make this work.
This works now perfectly, thanks for all your help.
Glad you were able to get it working. Happy to help!
Happy to help!
I saw that Paul answered already and that you've got it working!!
Let me know if I can help with anything else!
Andrée
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…
