Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hello!
I'm trying to figure out a formula to return the highest value from a range as long as it matches certain criteria. In the screen shot's example-- I want (in column 'Highest Day Late') to return the value of the highest past due date based on the range only if it includes the name from the Primary Column.
Please help!
try using:
=Max(Collect(
I've posted a reference below on how to use collect
https://help.smartsheet.com/function/collect
That is perfect, thank you!!
I have a Parent row that is showing this =MAX(CHILDREN()) Which I definitely need. The intent is to show if an institution needs to change hours if there's a positive number. However if there's 0 or a negative, the institution is on track. However, the formula is also showing the highest negative number if the institution…
Not sure what to title this, because it's not really Cell Linking the way we talk about it with Smartsheet… I have two sheets, Project Sheet has project rows and a column that lists animal species impacted (currently text, but could be multi-dropdown if that helps?). The second sheet (Species Sheet) has "more info" on…
I need the Date of Sample Shipment to start within 20 days of the Date of Manufacturing Start Date. However, the predecessor I have there isn't working properly. What should it be? Thank you so much
