-
Tasks cannot be linked with predecessor if date is fixed in past
Tasks cannot be linked with predecessor if date is fixed in past, MS project will allow start or finish no earlier than date with a predecessor allocated to drive the date accordingly. Are there plans to add functionality for task dates to be start or finish no earlier or later, with a predecessor allocated driving the…
-
Children reporting to parent - Checkbox and checking status
Hi guys! I'm having a hard time figuring this out. I've tried to copy and edit all the formulas in this forum, so now I'm just asking the pro's. Two questions: I need to have the cell marked 1. on the picture check the children cells. If they are S5 it shoud say S5. If it's not (S0, S2...) it should say 0 (or blank). Mark…
-
If this then that...
I am simply trying to create a formula that IF the job code is this, then it auto populates the corresponding Job Title into another cell. Is there a way to do this?
-
Formula Woes
My old formula: =COUNTIFS({Implementation Rollup Type}, OR(FIND("new", LOWER(@cell)) > 0, FIND("exist", LOWER(@cell)) > 0), @{Implementation Rollup Work Start}, IFERROR(WEEKNUMBER(@cell), [1/7/19]$1) <= [1/7/19]$1, {Implementation Rollup Work Finish}, IFERROR(WEEKNUMBER(@cell), [1/7/19]$1) >= [1/7/19]$1, {Implementation…
-
Checkbox formula with percentage
Smartsheet guru's-- I'm still learning how to use all of Smartsheet's assets. I am trying to show a percentage for checked boxes. Can someone help me with the formula part? Thank you!
-
Formula to create a number assignment catalog
Hello, I am trying to create a number assignment catalog that is automated to speak to a smartsheet that has my full collection of products. The goal is when creating a new product anyone could fill out a form select the category numbers that will define the department and then select a a number that will identify the…
-
Pulling data from a sheet
Good Morning, I have a report that I do monthly that records the data from the following sheet. At the end of the month I usually filter columns and manually count errors for each responsible party and move them to a another sheet that records each persons errors for the whole year. I record data for about 30 individuals…
-
sequential number for each parent row - column formula
Hello im trying to generate a sequential number for each parent row. I can do this using an helper column called parent that flags each parent record with 1 then the formula @row, 1) this won't convert to a column formula because of the explicit row references used to define the range. can it be done. any help appreciated…
-
Accounting for the word "Perpetual" in a date field when there is no end date
I am currently running this formula: =[Contract Expiration Date]@row - [Notify days to renew/cancel]@row to calculate the date when we need to review a contract. It essentially takes the end date of the contract and subtracts the numbers of days specified in the contract if you want to cancel. We have some contracts with…
-
Column Formula not selectable as Gantt Label
Hi Folks, Is this a bug? For Gantt chart labels, I use a column that concatenates and formats the task and end dates; call this column "Gantt Label". I select this as my Gantt label and it looks great. To prevent my formula from getting corrupted or broken, I convert "Gantt Label" to a Column Formula. Here's where it gets…