-
Match or VLookup?
I cannot figure out how to cross reference two excel documents for changes made from one day to the next. Long story short, our EDI process is not working at this time. Until it is up & running, our csr is required to manually review each page for changes from the previous day. It is so time consuming but until EDI is up &…
-
Counting unique values over different date ranges
Pretty new to SS, I've only been working with it for less than 2 weeks. I have a sheet with pto requests, I need to count the number of team members that have submitted a quest in a quarter or a year or whatever date range I need. Team members can and have submitted more than 1 request per quarter/year ect. So basically I…
-
Formula Help- Check Box if Date is tomorrow
Hi! I need a formula so that if a date column is the next day, a box is checked. This is what I've started, but I can't figure out how to say- if the date is tomorrow... =IF(date:date=????,(1)) Any ideas? Thanks! Amy
-
Hyperlink to a row/cell in the same sheet?
I am working on an "issues log" in smartsheet and I want the ability to respond to duplicate issue by marking it as duplicate (checkbox) and the next column (Duplicate Of) place the auto numbered row number of the duplicate issue. I would then like to put in the next column (Duplicate Link) a hyperlink to jump to that row.…
-
View Ranges Used in a Sheet (or all sheets)
Hello, I would like to know where I can go to make edits to some of the ranges I created. Normally, I can see the ranges I have created by just clicking on the cell once (rather than double-clicking to edit), but my formula is too long and it pushes the range links off the page. Please see attached screenshots. Any help…
-
Checkbox populate contact list
Hello all, I am hoping someone knows of a formula that could automatically populate a contact list when a checkbox is ticked. It is a sheet that keeps track of inventory and I would like to be able to keep track of who is breaking the minimum quantities without relying on the person to use a drop down box to insert their…
-
Counting Checkmarks within a Column
I have a bunch of products, each listing a different product. Each row has a different client, with their contracted products. I want to have a sum of each prodcut at the top, but the columns are checkboxes. So I'm trying to do a formula that says Count if the the box is checked, so I can know how any products are sold.
-
Counting total rows that fall after a specific Date
I am looking to create a formula that will capture all active rows that I have that fall withhin a Fiscal Year of 10/1/17 through 9/30/18. As of right now for the new fiscal year of 10/1/18-9/30/19 I have the following equation: =COUNTIFS({End Date}, >=DATE(2018, 10, 1), {Doc Type}, "Master") I am looking to capture the…
-
Adding formula in column automaticaly
Hi, is it possible to have formulas added automaticaly to in every row in the column? e.g If someone adds new row or delete it by accident.
