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:
Looking for a way for my Vlookup function to retrieve multiple responses from the table. I currently have it set to find the purchase order number associated with the work order, but sometimes there is more than one. Has anyone seen a way to do this?
You could use a JOIN(COLLECT along with cross sheet references. If you're able to give me more details as far as column names/sheet names, we may be able to piece something together for you.
I have had success in doing this via ODBC and using the data in an excel spreadsheet to format orders
Thank you! I was able to get it to work!
Excellent! Happy to help.
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
