Sign in to join the conversation:
I'm trying to report down the same date as my parent date. Of course this simple formula is not giving me the results I need.
I need the parent date for each job
You do not need a reference in the PARENT formula. Absent a reference, it will use the current row.
Hi Gina,
Try this.
=PARENT()
Did it work?
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
A little explanation as to Andree's correct solution.
Your formula of
=PARENT(Week3)
is saying to look at the parent of that cell. Week3. If you look at the parent of that cell, you will see that it is blank.
To reference the cell that the formula is residing in
=PARENT(this cell that the formula is in)
you would just leave out the cell reference.
I am working on a column formula that won't generate a syntax error due to the first-row data entries. The goal of this sheet is to document and calculate changes in counts from a one month to another. A form will be used for data entry, and I have the form set up to put new entries at the bottom. The formula in the…
I created a master sheet that will list all projects for a department. We will also have a planning sheet for each project in the master sheet, created by copying one of four templates (based on the project type). Each of the four templates will have columns set up and a hierarchy of rows based on phases, workstreams,…
Hi everyone, I'm hoping someone has run into this and found a fix. After a recent Smartsheet update, my automation that sets the % Complete column to 100% when a task is marked complete is now populating '100 instead of 100% — storing it as text rather than a number. This is breaking my downstream schedule logic that…
