-
Each data point as a new variable?
Hello! I am fairly new to setting up a dashboard but I am trying to visualize a summary of some of our survey questions. I uploaded our numeric dataset to Smartsheet and then tried to create a chart focused on a question about income level. There are seven response options for this question, and you can see on the pie…
-
Count Past Due Task and Exclude Status that is Complete
I am trying to count past due tasks but exclude any tasks that are past the End Date. Below is my current logic that is NOT working. =COUNTIFS({P904 - Walkthrough Past Due}, AND(@cell < TODAY (), AND(@Cell <> "Complete" ))) Below is logic that is counting all items that are past the End Date =COUNTIFS({P904 - Walkthrough…
-
Sheet Change Notifications keeps getting unchecked by the system!
Sheet Change Notifications keeps getting unchecked by the system! TWICE in the past week I have had to go in, check the box, and Save it. PLEASE FIX THIS SMARTSHEET! The only way I know it is broken is AFTER I run an automation and I do not receive the notification.
-
Create a custom auto increment based on a condition
I am trying to generate unique ID codes for each line item. The ID codes are: TYPE + "-" + YEAR + "_"+ #ofTypeinYear + "_" + PLACE. I am struggling to create the "#ofTypeinYear" column. This column should be able to scan the ID CODE column, and find the max "#ofTypeinYear" in the code for the items that have the same type…
-
Error when submitting a form.
Workspace owner has created a form and published it. Users that are members of the workspace receive an error when attempting to submit the form. Error message is: There was an error submitting the form. Please try again. If the problem continues, please visit www.smartsheet.com/gethelp. The user/owner of the form has…
-
Formula for highest education level
I am currently creating a visual for 150+ people's education levels, dropdown columns shows a majority of people has up to an masters degree but around 10 of them have doctorate/Ph.D. on top of it. What is a formula I can use to count the number of master degree holding individuals whilst EXCLUDING those with…
-
I need a date cell to change based on the date of another cell
I have three date columns. The first date column is the master. The second should reflect one week before the mast date column. The third should reflect one day before the master. Bothe the second and the third date columns should auto update based on if the master date changes. How can I accomplish this?
-
Impact/target Multiple rows within the same group
Is there a way to impact multiple rows using a workflow? If I select "No", on "remote access" Column, I want the system to populate "Yes" on "was report delivered" column and today's date on when was the report delivered. "This is already happening successfully on my end" However, I want to target rows 3,4,5,6 with the…
-
Option to sort by sheet owner is missing?
Hi all, When looking under "Browse > sheets" I no longer have the option to filter the list by owner. Is that option gone or is there a way to get that option back? I work for a large company & am constantly being shared to new sheets + creating my own new sheets. When the sheet name is changed, the only way I can…
-
Exporting Smartsheet calendar to Outlook 365
I'm struggling to export Smartsheet Information into Outlook 365 calendar. I'm trying to create a group calendar specific to resources(people) assigned to task(s) within my SmartSheet schedules so to have each individual assigned to a Smartsheet task in order to get an overall view of each persons time spend on multiple…