-
SUMIFS/VALUE
Hello, On sheet A, I have 2 columns (among many others) . Column1 contains a LEFT-formula that returns 3 digits. Column2 contains a LEFT-formula that returns 3 digits plus a hyphen and then 2 more digits. On sheet B I have a SUMIFS formula that references sheet A. If I reference column2, it works. If I reference Column1 it…
-
Need help with date reporting formula
I have 4 formulas in seperate cells that look at open and closed actions and does a count of how many there are for those months. The current formula for the current month:- =COUNTIFS({Date opened}, >=DATE(YEAR(TODAY()), MONTH(TODAY()), 1), {Date opened}, <DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1)) works fine and has done…
-
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!
-
Cumulative sum that adjusts based on current month
Hi Team, I have 2 columns in the sheet One is Month and the values are Jan, Feb, Mar,…. Dec Another column is $ value against each of the month. All I need is that based on current date/month, the sum value for Previous month and Current Month sums up. All I need in a separate cell value to just sum up for Current and…
-
Mirror Row
I have a list of employees on one sheet. Can I have that column mirrored to another sheet so changes are made in real time and I don't have to update two sheets?
-
Formula for a parent row to populate status based on children status
Hi! I looked through the community for similar posts, but can't get quite there with previous posts. My instance is slightly different than the ones I could find and I have been unable to modify it accurately. I am trying to populate the status on the Parent row (grey bar in image below) based on the statuses in the…
-
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?