-
Integration with Teams
Hi everyone. I have a series of dashboards that are linked to each other, which I would like to be available for viewing to my coworkers in MS Teams. I can add Smartsheet as an app within Teams, but it seems to only want to add one dashboard per instance/tab of Smartsheet. I have 50 project dashboards, and adding 50…
-
Equation Assistance for Metric Sheet - Counting Survey Responses
Hello - Can someone help me with an equation? I have a From that I'm using as a survey where I have collected answers to 4 questions with the options: Strongly Agree, Agree, Neutral, Disagree, Strongly Disagree. I want my equation to count how many of each answer we received per question on a metric sheet so I can display…
-
Resource Management Joined() Contact Column unavailable.
I have groups where I need to limit the contacts to I would like to track my resources but my "Assignee All Row": It uses: =IF(ISBLANK(JOIN([Assignee Design Architecture]@row:[Assignee Sign-Seal]@row)), "-", JOIN(COLLECT([Assignee Design Architecture]@row:[Assignee Sign-Seal]@row, [Assignee Design…
-
Why can I only edit a sheet on my phone and not my PC
I am sharing a smart sheet with a business partner and we were working off the free plan at first. When the 30 day trial ended I could no longer edit so we both purchased the pro plan. However, my PC version of the sheet is still view only yet on my mobile app I am able to make changes as per usual. We have tried removing…
-
Quarter Formula
I am trying to create a formula that extrapolates the quarter (Q1, Q2, etc) based upon the end date column. Has anyone done this before? Thanks in advance for any help provided.
-
Count Every Time Two Specific Dropdown Items are Chosen
I have a dropdown list in a column named "Status" where we track the progress in a process. The dropdown list contains the following choices: Initial Testing Ready for Review Ready for Retesting Ready for 2nd Review App Support Request Submitted Completed ON HOLD No Longer Needed I'd like to count the number of times that…
-
how to send the update request with only column having the particular value
I have a form where there are Mutiple fields with dropdown and 5 different value for each as below 5 - Excellent 4 - Good 3 - Fair 2 - Low 1 - Poor if the user enters Low and Poor then only that particular field should be sent as update request. How this can be achieved
-
The sum of values in the next row
Hello everyone, I'm having difficulty writing a formula and would like to ask for your help. If in the fourth column of the image below, a risk condition has been identified, I would like to sum the values below the row where the risk was identified, without including the row classified as a risk in a new column right…
-
What am I doing wrong in this formula?
=IFERROR(INDEX(COLLECT({Master Unit/Manager List WI Range 1}, {Master Unit/Manager List WI Range 2}, [Site]@row, {Master Unit/Manager List WI Range 3}, [Department Name]@row),[{Unit/Manager List WI Range 4})) My goal with this formula is: if SITE and DEPARTMENT Name on Sheet1 matches SITE NAME and DEPARTMENT NAME on sheet…
-
Making a Dashboard from a Form
Hello, I am trying to connect a form all the way to a dashboard that will give real time updates and require no manual intervention once made. The form is sent to a group of individuals that will eventually have to be separated out into separate units for which they work for. I am thinking of doing an automation that will…