- Comments does not target the people when used @
Hi all, I'm using work apps to collaborate with multiple depts. I have collaborator access and when my team uses @sample name to target someone to get notified, 1. the names don't take @, and 2. no one is getting notified. I really need some help here to figure this out. I am not sharing a workspace, I'm using a report in…
- Trying to ignore the error cells and calculate average for the column
I've been trying to ignore the cells which have #invalid data type calculate the entire column with numbers. Please see attached. I've tried iferror as well with no luck!! Will highly appreciate if someone can help out!
- How can I change the priority automatically based on a due date
Hi all, I have multiple rows of materials that need to be released before the due date, I have categorized them in Critical priority, Priority 1, 2, and Regular. Is there a way that smartsheet will automatically change the priority based on the due date entered if my team has not yet addressed the row?
- How to activate commenter permission in workapp?
I have an enterprise license with workapp collaborator access. I need a few of my collaborators to have commenter access without any other permission. Can't find it anywhere how to activate this. Any help is appreciated.
- Forms and Duplicate Entries
Hi all, I'm trying to avoid duplicate entries that can be transacted through the form I created. I have several columns but a batch number is a unique identifier for the entire row. Is it possible to delete the duplicate row based on the unique batch # or move it to a different sheet? or trigger a flag on that duplicate…
- How do I create a search function in a sheet?
Hi all, I was wondering if there's a way to create a search function in a sheet or on a dashboard where it will draw specific columns for that material from another sheet. I don't want to share the master sheet with the audience. Thanks =)
- Interacting with reports error
Hi all, Running into an issue. So I have 5 depts that will be updating their progress in a lifecycle management of the product I'm tracking. I have created a sheet where I get all the overview and have conditional formatting whenever someone clicks on the checkbox their portion becomes green. The issue I'm running into is…
- Sorting ascending order (monthly)
Hi, I'm having trouble organizing the column in ascending order. I'm trying to plot this into the dashboard and after Jan comes Oct as I'm trying to group them together. Before I tried not to put a number before the month that messed up the order more. Not sure how to fix it. Any input will be appreciated.
- Getting errors on ignoring the error cells while calculating the average for the column
Hello all, I've been trying to get an average for the column "Planning notified- QSTO generation". I want to ignore the #invalid data types cells and calculate the average of the column. I was suggested to use iferror but I'm not sure how to place this as a formula as it needs to return something if error is found. I need…
- 如何计算时忽略错误公司ng the average?
I'm trying to calculate the average of the "planning notified -QSTO generation" column and ignore the invalid data type. I've tried the attached averageif formula but it seems to be not working! getting invalid data type. Highly appreciate your help! Thanks =)
