-
Find the Count of All Multi-Choice Answers
Hello all, I'm still a bit new to SmartSheet, so forgive me if I'm a bit ignorant here. I have a column that has several multi-choice options (Option A, B, C). I would like to know how many times, across all rows, each option was selected. The setup would look like this Row 1: Options A and B selected Row 2: Options A and…
-
Creating a chart from non numeric values
I have created a form for users to fill out based on their experiences with a certain process. They will be asked questions such as "were instructions clear" and they can answer Very Clear, Somewhat Clear, Unclear. I was trying to create a pie chart from this sheet that shows how many users selected Very Clear vs. Somewhat…
-
Active turn around times by status of a row
I was wondering if theres a way/formula to track the amount of time a line stays in a certain status. For example - If we are using a line to track the life cycle of a contract we would have a created date field and a contract status field. The status field would consist of fields like "Contract Review" "Legal Review" "On…
-
Format of Automations
Apologies in advance if this has already been asked, however, I struggled to find an answer on this when searching in both the community pages and the help guides. I'm convinced I've previously been able to apply a setting on automations, such as alerts/notifications, which allow them to be displayed either vertically or…
-
How to show a "Completion Status" column based off of certain cells containing value?
Hello Smartsheet community, I have a database containing the amount of training specific employees have received. I would like to create a formula that is able to recognize what level someone is at and then the training needed for that level. If they have received the training it would show as "complete." If they have not…
-
Creating a Workflow that Auto-populates a Form/Sheet
Hello, I was wondering if it is possible to create a workflow that once submitted and approved would auto-populate a Sheet or Form. Currently we use Support Central to capture associates Name and unique identifier. Once the workflow is approved the end user manually types in the requester's information from the workflow…
-
Formulas in Reports/Reference reports for Dashboard
I read in the community (the posts were a few years ago) that you cannot enter formulas into reports or that you cannot reference reports for a dashboard. Is this still the case? I having living data that really needs to be manipulated to get it prepared for a widget. I'm new to smartsheet and it seems like reports are the…
-
Meeting Minutes Crossover/Linking
Hi, we have numerous live projects at any one time, e.g. Project A, Project B, Project, C and so on. We hold weekly Project meetings on each project and keep notes and assign tasks in a Project Meeting Sheet. Separately to this we hold other a number of other meetings such as Design meetings, Production meetings, etc where…
-
Choosing a Task List vs a Project
So, I have a question that on the surface might have obvious answers but want to think through the potential implications for choosing a Task List vs a Project. In theory a Project should have a defined start and finish for all tasks. A Task List essentially becomes a "to do" list. Tell me what I might be missing please.…
-
IFTEXT vs something for numbers not just text
Hello Community, I am using an IFTEXT function to automatically check a box in one column if the cell in another column(s) has text in it. I also need it to check the box when the other corresponding cells have, not only text, but numbers as well. Is it possible to combine the functions to allow for an "OR" command that…