Best Of
Re: Hello! I am trying to make a graph with these dates!
I was not able to put it in a reference sheet but I did figure out the formula I needed and just put it below!
=COUNTIFS([Start Date]:[Start Date], AND(@cell >= DATE (2021, 1, 1), @cell <= DATE(2022, 12, 31)))
She18ee
Re: Nominate Peak Humans & get a badge!
I nominate @EEK for the Peak Human Badge. She breathes Smartsheet. Even on her days off, I can call her and she will drop what she is doing to help me with a Smartsheet question. And I don't mean just for a 5 min conversation. We are talking hours on a Teams call. She doesn't look the slightest bit annoyed by it. She loves Smartsheet! You can tell.
Angie Bryant
Re: Variance on time or behind schedule collumn
Hello @Joechaptaylor. Try something like:
=if(Variance@row="","",if(Variance@row>=0,"On Track","Behind Schedule"))
Philip Robbins
Re: Index(Collection formula for dropdown field with multiple entries
This can certainly be done if I understand what you need correctly.
You want to take all selections from the [Blockers] column and output a group or groups based on those selections made.
My suggestion would be a helper sheet that has all blockers listed in one column and their group in another column. Then you would use a JOIN/DISTINCT/COLLECT combo to grab each of the appropriate groups like so:
=JOIN(DISTINCT(COLLECT({Reference Table Groups Column}, {Reference Table Blockers Column}, Has(Blockers@row, @cell))), CHAR(10))
Paul Newcome
Re: Form Access Message
Thanks @Vivien Chong, I agree with this approach and tried to locate and format it so it's as easily visible as possible. Not perfect, but perhaps the best I can do!
electrichead
Re: Can you setup an automation that pulls from an "email address" column that's not a contact column?
@Kristen Christman It has to be a contact type column for the automation to read the email address provided upon submittal. You do not need to have a full list of contacts added.
Razetto
Re: Business plan. Limitations on the number of dashboard widgets. No access to Team workload tracking
It sounds like your account may be associated with multiple plans, and that your default plan is defaulting to the Pro Plan, which has a limit of Widgets.
You can check what your default plan is by clicking on your account icon in the bottom-right of your account, then selecting Personal Settings and then going to Plan Info.
This Help Article has more information:
Let me know if this helped!
Cheers,
Genevieve
Genevieve P.
Re: Is there a formula to update the status based off the % complete?
Thank you that worked!
Deb Wardlaw
Re: Updating a Parent Row Based on Children's Status
Hi @Tony Fronza,
See if this works out better for you.
=IF(CONTAINS("In Progress", CHILDREN()), "In Progress", IF(COUNTIF(CHILDREN(), "Complete") + COUNTIF(CHILDREN(), "Canceled") = COUNT(CHILDREN()), "Complete", "Not Started"))
Notes:
- This can only be put into the parent row, cannot be a column formula
- If any of the [RFP Status]@row cells are blank, this will not work as the COUNT formula only includes cells with values
Hope this helps,
Dave
DKazatsky2