-
COUNTIF for Items in Dropdown Menu and Name From Another Column
I am trying to make a metric sheet to populate information for a dashboard. The originating sheet is from a survey/form. I would like to count how many times each category is paired with the Highest Level Person in Attendance column. For example, How many times the SVP is attending the Internal Audit Program topic?
-
Dynamically referencing parent task row in COUNTIF/COUNT formula for child task completion ratio?
Hello Smartsheet Community, I'm trying to calculate the ratio of completed child tasks for a specific parent task in my sheet. Currently, I have a formula that works when I manually specify the parent task's row number: =COUNTIF(CHILDREN([Task Complete?]70), 1) / COUNT(CHILDREN([Task Complete?]70)) However, I want to make…
-
Calendar view in workapp
It would be nice if the workapp supported a calendar view for an easier user experience and interface
-
View Multi-Day Tasks in a Report Grouped by Day
I have built a scheduling tool in Smartsheet for my Team to track standard, ad hoc, training, and PTO. I have setup a report that pulls scheduling data from multiple sheets with tasks grouped by start date. I use this report to see how my Team is scheduled during a given week. Unfortunately, in this report, tasks that…
-
More than 2 actions following an approval
Is it possible to have more than 2 actions after an approval in the same workflow? We have a sheet that requires the tasks to be approved by a member of leadership. If it is approved I need the project lead to get an alert, the date to be recorded, and the status to be changed. I would prefer not to have multiple…
-
Change Permissions for Specific Items in Workspace
Hello all, Can we change permissions for a folder inside the Workspace? We have given Editor access to the workspace to some people and we would like for those to change their permission to Commenter for the folder we have created. How could we achieve this?
-
Welcome to the Education Community!
This is a space for Smartsheet users that work in the education industry to connect, share ideas, challenges, best practices and how you are using Smartsheet to transform education. My name is Julie, I lead Education marketing at Smartsheet and am excited to get to know you all. I will be sharing helpful resources,…
-
summaries in report
Hi i'm trying to build a report with summaries options. i have two column that i want a Min and Max summary. the column for the Min i a texte column and works well. but the other column has formulas and the Max doesn't works. there is a way to fix that? (instead of creating another text column in the source sheets?) here…
-
How do I fix a blue screen error (BSOD)?
How do I fix a blue screen error (BSOD)?
-
Project Status Formula and Checklist items
We have a project checklist template that is provisioned via Control Center. There are hidden columns (the "Task Not Needed" referenced in the formula) that show only the checklist for the Project Type selected in intake - the tasks that are not supposed to appear are checked because all the project-specific checklists…
