-
IFERROR Not Returning the Correct Message
Hello! I am using an IFERROR with Index/Match and it will not return the error message of "Pending" as I am requesting in the formula, it just shows blank. I'm not sure why: =IFERROR(INDEX({Data Dump || Pre-Hurricane - iFormBuilder Range 2}, MATCH([Building Name]@row, {Data Dump || Pre-Hurricane - iFormBuilder Range 1},…
-
Can you use 'contains' function within Report Builder...
We are pulling in a field with our JIRA Connector that has values separated by commas. Example of Data the column labeled Product: First row of data has: AK-HO Second row of data has AK-HO, AL-HO, AL-DP Third row of data has AK-HO, NY-HO, CA-HO I need to report to tell me each each row that has AK-HO in it. However the…
-
Calculate difference between dates if populated, return a different result if not
Hello, newcomer here! Trying to work out the best way to calculate the following please: If Date X = blank, return result 'overdue' If Date X = populated, calculate difference between Date X and Y Following on from that, I need a following column to return Yes if date is <1, or No if date is or overdue. Thanks in advance!!…
-
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…
