Hello, I have a specific cell. When a value is entered into this cell, the person who entered the value should fill out a form from another sheet. I've tried to implement this through a workflow, howe…
To move specific column values from my source sheet to another sheet, I can't use a lookup formula because the entries in the source sheet are constantly changing and not permanently established. In m…
I have a cell where different numbers are always entered. Most of the time, this field contains a leading 0. With a leading 0, the text is left-aligned, but with any other leading number, the text is …
I want to scan a barcode into a column in smartsheet forms with the following information: barcode text: Name, Typ des Gerätes# QNummer$nicht zutreffend%Benutzer As you can see there are different del…
I have built a formula to collect the information of a row, when a selected row, fits another row. =IFERROR(IFERROR(JOIN(INDEX(COLLECT({Probenabgabe Bereich 2}; {Probenabgabe Bereich 3}; HAS(@cell; ("…
I want to count if the cell of one sheet fits the cell of another sheet. I also want it to fit when both cell values are empty (blank cell) How does it work? =COUNTIF({Entnahme Bereich 5}; HAS(@cell; …