-
Smartsheet Sheet Summary - Not Able to Show % in Sheet Summary using Join formula
Hi All, Hope you all are safe and well. Question : Is it possible to show a percentage (%) in my sheet summary by using a =JOIN formula? I would like to use this so I can use the metrics widget in the dashboard. I have created a formula to show value (in percentage) whenever a checkbox is checked. This is working. Then I…
-
Copy Contact to Another Cell if Entered
I have five contact columns one table. I have set up the webform where a contact can only be entered into one of those five cells. My question is, if a contact is entered into one of those five Contact cells, how can I copy that information into another cell on the same row?
-
RYG-ball with nested IF statement (combined with AND)
Hello community, I simply want to change the status of a RYG-ball by comparing two conditions. If Condition1 AND Condition2 are FALSE than the ball should be RED. If Condition1 AND Condition2 are TRUE than the ball should be GREEN. In any other case the ball should be YELLOW. When building the formula, this worked as an…
-
Report to itemize responses
Hello! I am trying to develop a report that will list out which Residents have selected which Attendings with whom they have worked - here is the sheet that comes from the form I've created - they just click the box for which ones they've worked with. I then want to be able to have a report that lists each Attending with…
-
Double a list of values in a cell
Is there a way to work with a list of values in a single cell? My situation is: a form user enters a submission, that populates a single line in a smartsheet. Each submission may have any number of samples, each which has a value associated it with it. Currently, the form user enters the values on separate lines in the…
-
how to keep the number of lines with formulas after moving certain lines? (Translated)
Après avoir déplacer des ligne je souhaiterai que la feuille de saisie garde toujours une trentaine de ligne avec des formules dans plusieurs colonnes. Lorsque l'on déplacer des lignes vers une autre feuille, le nombre de ligne avec les formules diminue d'autant (même en utilisant le "@row" Comment peux t-on éviter cela ?…
-
Help on Countifs Formula
Hello Smartsheet Community, I'm looking for some guidance on a countif formula. Specifically, i'm trying to count a specific request type where multiple types of requests can be submitted with a single request. My current formula is counting my criteria, however if another type of request is selected i.e. 2 or more, it…
-
Formula: 5 Checkboxes in Nested IF statement
This discussion was created from comments split from: Check Box & IF Statements.
-
Create a formula dynamically
Hello, I would like to know if its possible to create a formula dynamically. I want to split my sheet in various sections, but i dont know when defining my template if the end user will add or remove rows, then i can only calculate the number of rows for each section by using an auxiliary column. Then my formulas need to…
-
Is Adding COUNTIFS possible?
I have a formula that looks at counting all instances where a certain unit in a hospital entered certain data into a master sheet in the last 7 days: =COUNTIFS({K Cards Range 1}, "High fall risk", {K Cards Range 2}, "FALL", {K Cards Range 3}, "GMH", {K Cards Range 4}, =[Facility and Unit]30, {K Cards Range 5}, AND(@cell <=…