-
Formulas for calculate number of days depending on list of value
Hi there, I need to know if it is feasible to obtain this formula : In a sheet, i can choose several option from a list of value ( checkboxes). If option A is checked, i add 1.5 days for ex. If i choose B, i add 1 day. If i choose A & B, i obtain 2.5. And so one. How can i create that in one formula? Any idea? Many thanks…
-
SUMIF formulas to unify 2 variables
Dear, I would like to ask for help with the following: I am creating a summary sheet to quantify sales by seller as well as by sales area. There are sellers who have the possibility of generating sales in different business areas. Therefore, as you can see in the first image I show this global summary sheet, however, in…
-
Using VLOOKUP for Approval Requests Across Sheets
GOAL: 1) Have a secure and error-free VLOOKUP on Sheet B and 2) Run a multi-level approval request automation on Sheet B. DETAILS: I have 2 sheets. Sheet A tracks contracts. It has columns for individuals (contacts) who are designated approvers for changes on contracts. Sheet B tracks providers named on the contracts to…
-
Nested if for RYG Balls and qty not working
I am trying to use the RYG balls when noting when a variance has gone over certain amounts: 5000 or less - Green 5000-10000 - Yellow over 10000 - Red I can add grey as my false statement if the coordinator has checked off the completed box. This is the formula I have tried to build so far but I get the Unparseable error. I…
-
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