About distantblue

distantblue · 11-29-2022

Just a question to clarify if something should workI have several sheets in Smartsheet and per the limitations the company has been archiving the sheets once they get full.Creating this app I am needing to compare things in all of these sheets. The m...

distantblue · 12-14-2022

thank you, one quick clarification while I work through thisa virtual column should display subtract() results without having to do an add? aka display in a table without having to hit + in regards to the in()IN(needle, haystack)needle - Any value to...

distantblue · 12-13-2022

MarcI spent some time on in() and subtracting list. A couple of thoughts/ questions/ observationsI have had the best results with ,list(MATCH TABLE[METERNUM]-FINAL LIST OF UNFINISHED INSTALLS RND BREAKOUT 2[METERNUM])this will create accurate results...

distantblue · 11-30-2022

thank you. I have been messing with filter and in with limited results. I will spend a few hours on this today and post my results. thank you for the direction.

distantblue · 11-29-2022

thank yousome context. when the tech puts in Old Meter Number or ERT i was hoping to evaluate if this item was listed in the MasterWorkListFirst20k. if the item existed in both list. aka the job got done today it will now have the status marked as do...

My Stats

Denisqqq's Bio

Badges distantblue Earned

Recent Activity

list compare

Re: list compare

Re: list compare

Re: list compare

Re: list compare