-
How can I get a list of collaborators with editor access?
Hello, I want to send an update reminder to people who have access to a sheet but only to those with editor access. There is a workflow to send reminders to "everyone shared to this sheet" but I only want to send it to those that will be able to edit (exclude viewers). Is there a way to get the list of editors shared to…
-
Jira Plug-in IT Support
How do I get someone from Smartsheet IT support to contact me? I received a trial version of the Jira plug-in but having issues get it connected and have been trying to contact support for 2 weeks now. I've created a support ticket, emailed my sales representative, and left a voicemail. Kind of getting frustrated with the…
-
Notification not sent to sheet owner
I have setup a notification that successfully sends an email to anyone that has been assigned to a task. However, if I assign a task to myself, I don't receive an email. Is this not receiving an email if you create the task or own the sheet normal? Mostly I was looking for the email to confirm I configuring the automation…
-
Can i remove multi-select from single cell?
Hi folks, Bit of a novice here, i have a challenge for you 😁 We use smartsheet for tracking holiday, sick leave, unpaid leave etc. For 2019/20 we've only had a single-select option for each cell, but this makes it difficult to track when employees work 1/2 a day and also 1/2-day Holiday or 1/2 day unpaid, on the same day.…
-
Best Formula to use to COUNTIFS based on several criteria.
I'm trying to come up with a formula that will return a number based on several criteria. I have a separate sheet that I have a key of allotted days off for each area (Vacation, Personal, Summer Friday, and so on). On that separate sheet, I have an available days based on the Key, minus the formula that i'm trying to…
-
how do you open file
I don't know how to open file
-
Nesting SUM, Decimal places, and %
I'm attempting to calculate the percentage of work that's done, round it to a whole number, and add a percent sign. I can get 2 of any 3, but not all three. =SUM(([Points Done]@row / [Total Points]@row) * 100) Adding + "%" to the end of the equation gives me 5 decimals. I'd also like to add an IFFERROR for when there are…
-
Maximum capacity Form
Hello, I'm making a form for people to fill in if they want to participate on a event. I made the form and set some dates that they can choose. The only problem is that on each date there is limited capacity. So what I would like is that when for example they choose 15/7 15 times than the date wouldn't be available anymore…
-
Inventory Barcode Scanner / Expiration Date help
I made an inventory grid. One column has a barcode and one column has the expiration date. The expiration date reads the last 8 digits of the barcode to output a string of numbers that is the expiration date. Is it possible to make it formatted into a date like "dd/mm/yyyy". Right now it looks like this "ddmmyyyy"
-
Create formula to count category risk with aggregate rating
Hi, I have a risk register for a project that has well over 100 risks documented and I have them categorized into 17 different risks. I would like to be able to create a formula to count how many risks exist under each category and then a formula to show the aggregate risk associated with this. I would think by a…
