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 man…
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…
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 bas…
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 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 inpu…
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…
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 a…
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. Sp…
