-
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…
-
Creating a percentage from multiple tick boxes
Hi All, This may be simple but i'm struggling to get an output so hoping you can help... I'm trying to calculate a percentage based on the number of completed tick boxes in a row/column. I'd be ok if this initially does a count in one cell and then coverts to a percentage in another. This is the example data below:
-
Avoiding a massive nested IF formula - checkboxes?
Hi all, I have 5 check boxes and based on these being ticked or unticked i want to display something in another cell. It is essentially a decision tree that simply i want to work as follows: If Group 2 is not ticked (or nothing ticked) = Group 1 If Group 2 is ticked but 3, 4, 5 & Close are not = Group 2 If Groups 2 & 3 are…
-
How do you create a contact list based on 2 seperate sheets using a Vlookup.
Hello, Looking for some assistance with an issue we are having populating contact lists based on 2 separate sheets using a vlookup. To summarize the attachment, we have a sheet with a list of account owners and their email addresses (Client Services Listing) that is feeding into another sheet (CSLS Teams by Account) which…
-
Expiry Dates - Compliance Check
Dear SmartSheet Community, I need your help. I need help in writing a formula that will track compliance for different areas based on expiration dates. If dates are active and will not expire in the next 30 days, health should be green. However, if one or more items in the row will expire in 30 days, yellow and anything…
-
How to reference another sheet in a formula
I've been trying to write a formula that will "Check a checkbox (in sheet A) IF [name] cell (in sheet A) is found in {name} column (in sheet B), AND the box in [checkbox] column (in sheet B) is checked." Basically, does a particular staff member's name appear on another sheet, and if so does it have a checkbox checked in…