-
Duplicates, can I count the Original but ignore 2nd, 3rd etc
Hi I had a look but couldn't find the answer. I am trying to do simple reports and formula Counts, but trying to ignore any duplicates. Example below, I am only interested in counting the first time a name appears, so the count would equal 5 Names, ignoring where there is a second or third. Names Andrew Dave Phil Sarah…
-
Customer Database
I'm looking for a way to track our applicant demographics. Any one have any ideas to track all your customers in one place?
-
How to get the sum only for a Specific Dropdown Value Selected
Hi, I want to get the sum for only the dropdown value selected: Here is the Situation: First Column: I have 3 Resource Type: 1. Offshore 2. Onshore 3. Remote Column 2: I have resource Name Column 03 to 35 is a Hour Cloumn ( Where it shows how mnay hours each of my resource is available to work) Now I need to calculate: 1.…
-
Copying names into contact columns doesn't assign
We have about 500 rows in a sheet that need to be assigned daily. A team member will mass copy names from Excel into the contact column of our Smartsheet sheet. I would like to use the filter by "current user" functionality but, when pasting names in, the contact column does not pick up that the names are actual contacts.…
-
C# SDK - A strongly-named assembly is required
Edit - I started from scratch rebuilding it, and that solved whatever bug was causing the issue. I still have no idea what was wrong. I'm using Visual studio/C# to make a dll for Office/VBA automation. This was working until the TLS 1.0 deprecation on 3/31. I updated the SDK to to the newest version using the NuGet manager…
-
Error in Smartsheet export?
Since this morning I get an error message when I want to download the login history. See screenshot below. Is that only me, or do other people have the same problem? Thanks
-
Document review/approval tracking
Interested to hear if anyone has setup a process in Smartsheet to track document review and approval. SOWs and Cost sheets need to be reviewed and approved by multiple people prior to being reviewed by the customer. I'd like to embed this process into an existing customer tracking smartsheet if I can but am undecided on…
-
save/replace a sheet
How do I save a sheet to an existing sheet so the sheet url is preserved? Basically creating a point in time snapshot sheet each week but I want my colleges to use the same url to view the snapshot
-
Dashboard objects multi selection
Hi, While I was creating the Dashboard (attached) I realized that it would be easier to select more the one object and move/change size/change font. But in real if I need to move many objects I have to select each object and move it separately - it kills a lot of time. Could you please inform whether you are going to…
-
shared with Active directory user
hi, i already integrated office 365 apps with smartsheet. i have question - can i share file with active directory user ? right now , for sharing content, i have to add that person on sheet. i need active directory integration with smartsheet so i dont have to add manually on sheet.
