-
Error when opening a sheet
As I finished working on a sheet last night I got an error message saying to log off and back on. I logged off for the night and now we’re getting the same error message when trying to open the sheet. When we use the search feature it doesn’t appear. When we go to the folder it’s there, but we get the error message when…
-
Cross-sheet Copy and then INDEX/MATCH Help Needed
I am working on developing an End to End Testers sheet and a Defect Sheet. When a scenario test has resulted in a Defect Confirmed, I would like the Scenario ID, Scenario Name, and the Scenario Description to be pulled into the Defect Sheet. My initial approach is to break this information into 2 cross-sheet formulas.…
-
Map for Location Data
Hi, Is there any map feature that Smartsheet provides (or third party) to show on a map data of a location-column on a Smartsheet? Thank you!
-
Dashboard Links/reports continuity when a user is removed from account
At least two times it has happened where a user contributed to the build of a Dashboard for a report or link. The user is removed from the account due to change in role. All assets are transferred to another user, however dashboard links or reports do not and fail to display. On the second go around this required a…
-
Symbol magically appears in a cell that is copied over to another sheet
I have a simple workflow that copies a row to another sheet. One cell is called a Job # and is populated with a number. When it copies over, the copied version has a symbol in front of the number. Example: '8282. I checked the original cell and no such symbol was accidently put in. Does anybody know what this is and what I…
-
Best way to cross-reference multiple sheets for repeated values only?
Hello all! Looking for some advice here. I have multiple sheets that track guests invited to events (5 right now, but it will continue to grow). I want to create a something that references them and lists only people that have attended more than one event and which events they have attended. So for example, let's say on…
-
Tracking a 1-day project based on time not date
I am helping manage a 1-day Disaster Recovery exercise and we want to track the tasks by start & end based on time of day. Would also like to auto adjust the times with dependencies - Does anyone know if a template is available of has anyone ever done this before?
-
Formula to find data in table with multiple columns based on 2 critera
I am looking for a formula that will look at this table and pull the hours per week based on 2 criteria – group and week. Right now, I have the tables separated so that I can use a vlookup formula. But that means I have to have 5 different formulas, 1 for each group. =IFERROR(VLOOKUP(ROUND(($[First Receive]@row - $[Week 1…
-
Automation Not Working?
Hello, I have an approval path for update requests. It starts with a form, and it currently isn't being received after being handed off by the PCM. So, starting on page 3, the Area Director isn't receiving the update request. I have myself filled in for most of the steps which will be changed once I get this sorted, but…
-
Data deleted in error earlier today, can I get it back? (Undo button not active)
Earlier today it looks like several columns of data had the "clear contents" action taken in error. Is there a way to get that back other than using the snapshot feature and manually adding it back to a sheet with conditional formatting etc.? thanks in advance for taking a look1