Best Of
Re: PTO Calendar
Actually, it worked! I just needed to change the sharing permissions, thank you @SK!!
Re: =NETDAYS formula updating in the afternoon
Hi @Erica Cole
Hope you are fine, could you please share a screenshot for the Time Zoon setting. because your formula is scorrect.
Re: Set Parent's Projected Date based on Children's Status and Projected Date
It sounds like you are using Dependencies in your sheet. If so, you won't be able to put a formula into any Date column used in your Project Settings or Duration column (see: Project Sheet Columns: Start Date, End Date, Duration, % Complete and Predecessors). You also wouldn't be able to change this column to be a text column because it would break your Project settings.
Instead, you could have a helper column that identifies this status, or if the row is a child row. Then you could use Conditional Formatting to make the values of your Duration and Projected Date look blank or greyed out until they are complete.... perhaps like so:
The formula I used in my helper "Percent Complete" column on the left is:
=IF(COUNT(CHILDREN([Task Name]@row)) = 0, "Child", IF(COUNTIF(CHILDREN([email protected]), OR(@cell = "In Progress", @cell = "Not Started", @cell = "")) > 0, "TBD", "Complete"))
If there are no Children for this row, then it's a "Child" row.
Otherwise, if the COUNT of Children that say "In Progress" or "Not Started" (or are blank) is greater than 0 (so there's at least one child that has either of these options), then it's "TBD". Otherwise, it's "Complete."
Would this work for you?
Cheers!
Genevieve
Re: PTO Calendar
Have to tried the Calendar App (if you do have that available for your Smartsheet account)
SK
Re: Health formula error
That's great, @Michelle Maas.
Also, thank you for your engagement and contribution to our community. Your inquiry is likely to assist other members AND it helps me flex my skills.
If you appreciate my response, please recognize the effort by with an "Insightful" or "Vote Up" selection. Thanks. Have a great weekend!
-Jen
Re: Introducing baselines for project management, available now!
Good point @Russell Baines
Feature Request:
- Assigning selected tasks to an existing baseline
- Support for multiple baselines
SK
Re: Introducing baselines for project management, available now!
Thanks for putting this new feature out there, Smartsheet team!
For example, if the Baseline date was 5/20/21 and "Actual" [Planned] date was changed to 5/15/20, per Smartsheet logic the variance is 5 days, whereas in reality it should be 5 days less than Baseline which should be shown as -5 days. It should be the variance from the Baseline and not variance of the Baseline
Hard agree. Thanks SK. Good feedback.
Re: Export Smartsheet attachments to OneDrive
We also have a huge need to trigger attachments to an outside folder location.
Currently, attachments are buried in silos. Smartsheet is not the final resting place for documents but is great for gathering documents from clients.
I hired a tech to create a Microsoft Flow (Power Automate) where if someone attaches a document, it gets copied to Sharepoint. I helped him. It was INCREDIBLY difficult, buggy, and quits working often.
Document management is a huge problem for us using Smartsheet. Is there a suggestion area in this community? I don't see one.
Thanks!
Re: Counting Parent Rows
Hi,
Create a text/number helper column [level] with the formula =Count(ANCESTORS()).
Parent rows will have a value of 0. Use level:level, 0 in your COUNTIFS formula to include parent rows.
To add other criteria your formula will use the syntax::
=COUNTIFS( level:level, 0 , [other range]:[other range], Other criteria)
For help with formula syntax see the link below.
https://help.smartsheet.com/functions
Help?
Mark
Re: Cross sheet countifs
There are a few too many parenthesis. Give this a go...
=COUNTIFS({Container COMPLETED Range 2}, "DTS", {Container COMPLETED Range 5}, AND(IFERROR(YEAR(@cell), 0) = 2020, IFERROR(MONTH(@cell), 0) = 1))
