-
COUNIFS formula when multiple contacts
I have a sheet with columns such as "Status of Request"(Dropdown list: New, In Design, Completed) and "Assigned Designer"(My assigned designer column allows multiple contacts). I want to count how many projects under the status "In Design" for Designer "Luis" do I have so I have the formula =COUNTIFS([Assigned…
-
Link to another sheet and add additional days
Hi there, I am trying to link to a master schedule but adding some additional days to define my drop dates. Please help. Thanks.
-
How to exclude values from a COUNTIF expression
I'm writing a COUNTIF formula referencing a column with multiple values that works well, until I try to build an expression that says: I want you to count the values in this column as long as they are NOT "x" OR "y" OR "z". Can anyone help with the proper syntax? I've tried the following but it doesn't work: COUNTIF…
-
SUMIFS Cross Sheet Issue
Hello Everyone! I am needing help with the SUMIFS formula for cross sheet reference but when I enter multiple criteria, it returns a value of 0. What I am trying to accomplish is a sum for Sheet-2 based on multiple criteria from Sheet-1: Criteria from Sheet-1 * Job ID* 216116 * Cost Code ID* 7 * 15 * 16 Sum Range: Act.…
-
Use of the system column to get the modified date
Hello everybody, I am trying to automate the input of the modification date of a particular cell on my sheet. I figured that since this information is already available in the system column [Modified] - I'd like to take that info to put it into another cell (with Date properties) Thanks in advance for the support Chris
-
Dependency Settings specific to each day
Is there a way to allocate specific hours on individual days e.g. Mon 7 hours , Tuesday 8 hours etc
-
IF FORMULA TO PUT AUTOMATIC STATUS
I would like to know what can I do to put automatic status for my monitoring sheet? There are 3 status: In Transit, Cancelled and Delivered. I want to know if its possible that when the requestor input the delivery date (refer to the screenshot), the status will change to "Delivered". For the Cancelled and Transit though,…
-
Select All/Unselect All for Outlook add-on attachments
I am curious as to whether there are others who would like to see a Select All/Unselect All for Outlook add-on attachments? I submitted an enhancement request but wondered if anyone else would like it or if SS is making me too efficient and I want less clicks .
-
Jira connector
Is there a way to create a template of the field mappings for the jira connector? We would like to establish a standard mapping for a set of our projects and we are looking for a way to either clone an existing workflow or upload a template.
-
How to create a future date based on a date in another column?
Hi, I am looking to create a formula in a column that automatically calculates the date of 12 weeks from the date of deposit column. Can someone please help with the formula? I keep getting errors. Specifically I would like the "estimated completion date" column to be the "date of deposit" column plus 84 days. Thanks! Keren
