-
Re: Function like UNIQUE in Excel?
I had a couple issues with parenthesis, apologies. =IFERROR(INDEX(DISTINCT({PM_List}), 1 + COUNT(PM$1:PM1)), "") Let me know if this works.1 · -
Re: Assistance with JOIN/INDEX and COLLECT function?
=JOIN(COLLECT([Key Supplier]:[Key Supplier], [Part Number]:[Part Number], HAS([Part Numbers]@row, @cell)), ", ")1 · -
Hours/Minutes in Project Sheet
I want to be able to make standardized work documents for changeovers/process information. I can't do that in smartsheet due to the lack of hours/minutes in the project sheets (I want to have the gan…3 · -
Re: Are you going to add the save feature for forms that are not completed in one session? Save as draft
Not exactly the same, but you can create an update request based off a checkbox, then label the checkbox "I'm not finished, i'd like to make changes later" or something to that effect.2 · -
Re: Multiple Countifs Using Symbols
Yeah sorry, I cut out the reference.... =COUNTIFS({Action Item Status}, "Canceled", {Action Item Due Date}, <DATE(2022, 12, 1), {AI Priority}, OR(@cell <> "Low", @cell = …1 ·