-
Anonymise form submission
Hi, I have a form which fills a sheet with an "Anonymise" checkbox column and a "Submitter" text box column. (staff feedback form) I'm trying to give form submitters the option to anonymise their submissions. At the moment, an individual has their own link which will auto-populate the submitter on the form but want to be…
-
Create a new row in Database2 when new text item is added to Database1
In my main project log (Database1), I have a "Customer" column with a drop-down list of all existing customer names; it is NOT restricted to drop-down values only so you are able to type in new customer names as well. I am using Database2 to assign each customer name a row to collect/sum specific data for all projects for…
-
Automate harvey balls with completion status
I am trying to automate the RGY Harvey balls in a sheet based on the status of the Full/quarter/half/three quarter/full Harvey balls.Below are the statements that I want to use but I was hoping to get some help putting them together in a nested if statement. if End Date is before today's date and Completed is full then…
-
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…