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 c…
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 …
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 id…
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 …
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 t…
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…
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 chec…
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 …