-
IF function in an INDEX formula
Hi - My below index formula works to capture the "2.0 Status" field; however, I am trying to incorporate an another piece to this formula that includes a job number. Not sure if its an IF or AND or additional INDEX function, but i want to pull this 2.0 status based on the "Project Kickoff Rec'd" line in the task AND for…
-
Date Based Automation Not Working
We have a sheet to help track when notary renewals are upcoming for staff and its a fairly simple process. We have a date column that lists the expiration date, a helper column that turns that into a total day count, status, and if an application was recvied. The trigger for this would be when that Days Until Expiration…
-
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…