-
Help with COUNTIFS formula
Hello all, I am looking for some assistance with a COUNTIFS formula. I have two columns of large data sets (staff ID numbers), one outdated and a new one representative of the current organization. My goal is to cross reference the two and see which IDs appear in both lists and which do not. I originally started playing…
-
Autofill Cells When New Rows Added
Hello! I am trying to figure out how I can autofill a column in a RAID Log sheet based on the project name entered in a cell in the Project Plan sheet. What I tried: First, in the RIAD Log I added a "Project Name Helper" column and linked it to the cell that has the project name in the Project Plan sheet. I then added a…
-
DASHBOARD - Shortcut Widget - changed?
I set up a Dashboard many months ago and it allowed me to put Links to WORKSPACES and FOLDERS from the SS Directory. See the Screenshot. I went to update the DB / add another FOLDER, and it would not let me. I had a consultation with a smartsheet basics person on the phone. They said not allowing WORKSPACES and FOLDERS is…
-
Allow multiple contacts per cell AND Restrict to list values only - Not Working
If I have a "contact" type column where I want to "allow multiple contacts" AND "restrict the list to the values" I've added to the column, then the list is not available. If I turn off the "allow multiple..." option, then it works as it should. Is there a restriction on contact type columns that disallows using both of…
-
Form Confirmation Options
I have created a purchase order sheet and form which auto generates a number each time. How do I reference this number to pull it through into the form completion confirmation message and/or email?
-
Why does my Start date column and my Received date column put in the same date?
I created this sheet 5 years ago to log contracts when received, the start date and end date. Just about a month ago, my start date and received date column input the same date. As if they are linked or joined but I cant see anything. Has anyone else had this problem? What can I do to fix it. I am now concerned this may…
-
V-LookUp to see if the same number ID is found in two separate sheets
Is there a formula that would check if the number ID in one sheet is also found in a separate sheet?
-
Phone Numbers and Street Addresses turn to Blue Font but only on Phone App
Hello, We have an interesting issue where all the phone numbers and street addresses we enter in a given row turn to blue font, but ONLY if viewing on the phone app. No matter what we do, we cannot figure out how to override this. It's an issue because a large majority of our conditional formatting relies on the use of…
-
Copy/Paste Permission Issue
I have a member of my team that attempted to copy/paste some information from a sheet where his permission level is "Editor - can share" to another sheet where his permission level is the exact same, but was told he could not. Full disclosure we have a workspace and that is his default permission level so anything added…
-
Create New Sheet from Report Results
It would be handy to have a mechanism for creating a new sheet from the results of a report. I envision an option in the report menu "Save Results as New Sheet" where you would be prompted to give the new sheet a name and then the report's columns and their contents (as static values) would fill out the new sheet. This…
