-
Concatenate cells with formula
How can I join numbers or text from 2 cells into one with a formula?
-
Pause "Days in Progress" counter
Within our SS solution we have a formula that starts a day counter from project status of "assigned" and stops counting when the project status is marked "complete". So if a project was assigned on the 5th day of a month and the project is marked complete on the 10th, it captures that the project was worked on for 5 days.…
-
How do I automate a Form?
I have a form in smartsheet that some of our Attendings will be using to fill out required shift information for payment processing. I know that on the base sheet I can set up an automation to request an update weekly which is what I need, but does that apply to the sheet the form info transfers to once submitted? Or will…
-
New Smartsheet Customer Resources 2
Community Share your product ideas and feature requests, connect with peers in your industry, find answers to all your Smartsheet questions and meet a fellow member through the Peer Connect program. Smartsheet Administration SmartStart System Administrator Webinar - System Admins are designated to manage users and adjust…
-
New Smartsheet Customer Resources 1
Community Share your product ideas and feature requests, connect with peers in your industry, find answers to all your Smartsheet questions and meet a fellow member through the Peer Connect program. Smartsheet Administration SmartStart System Administrator Webinar - System Admins are designated to manage users and adjust…
-
Wie füge ich Anhänge in automatisierte E-Mails ein?
Hat jemand Erfolg damit, dass SmartSheet Anhänge in die E-Mails einfügt, die es aus dem von Ihnen eingerichteten Workflow sendet? Derzeit ist mein Auslöser für den Workflow, wenn sich die Daten in einem bestimmten Feld ändern. Meine Aktion besteht darin, „jemanden zu warnen“. Ich habe „Ein Anhang“ als einzuschließendes…
-
Formel zum Zählen von Elementen in einer Multi-Dropdown-Liste
Hallo Ich habe gestern mit der Mehrfachauswahl-Dropdown-Liste begonnen, aber ich muss die Formel verwenden = countif (Bereich, Kriterium) Ich möchte zählen, wie oft ein Wert in einem Bereich mit mehreren Werten wiederholt wird. Bei dieser Formel zählt countif nur, wenn der Wert allein in einer Zelle steht, und ignoriert…
-
Title
=IFERROR(MID("!" + JOIN(DISTINCT(COLLECT(List:List, List:List, @cell <> "")), "!") + "!", FIND("|", SUBSTITUTE("!" + JOIN(DISTINCT(COLLECT(List:List, List:List, @cell <> "")), "!") + "!", "!", "|", Number@row)) + 1, FIND("|", SUBSTITUTE("!" + JOIN(DISTINCT(COLLECT(List:List, List:List, @cell <> "")), "!") + "!", "!",…
-
Test Add On Question
Test Add On Question
-
New Question
API Question