-
extract city & state from a city, state, zip cell
I want to extract the city & state from a cell that has the city, state and zip code. The zip code may not always be 5 digits (either 90210 or 90210-1234) and the City and State may not always have a comma separating them. A formula that can extract any text left of a numeric value is what would solve this, but I cannot…
-
Information page
I would like to have a sheet with all of my part numbers and the various information that pertains to each part number on it. I would then like to have some sort of sheet or report that has a dropdown for me to select the part number I am looking for, then it will populate all of the information for that part but in the…
-
Possible to create a URL/Hyperlink for new item (Automatically)?
We would like to create a URL/Hyperlink for new item automatically...in the attached example I had to 1) Manually go to row, 2) Select Properties, 3) Copy the Row Link, 4) Paste the Row Link in the field. We would like this to happen automatically, so far everything I have read says it is not possible. Someone have a…
-
Merged: Include column description in Report
This discussion has been merged.
-
SUMPRODUCT Workarounds?
Hey all, I'm evaluating Smartsheets for my business and trying to determine whether workarounds exist for some necessary calculations. Three big ones are cost calculation, weight calculation and inventory management. I currently use Excel for these. My arrangement is I have all our products on the top row, with all of our…
-
Sheet Filters on Reports
Sheet filters are extremely useful ways to view sheet information, it would useful to have the ability to select a sheet filter when developing a report to avoid having to duplicate the filter setup process.
-
Schedule Health Balls Change Based on End Date and Status
I'm looking to have the schedule health balls change color based on the "Status" and "End Date" columns. Green = "Complete" OR "In Progress" with more than 2 days to "End Date" Yellow = "In Progress" with 0-2 days to "End Date" OR "On Hold" Red = Not "Complete" after the "End Date" Thank you!
-
How to track training hours across an organization
Hi, I need suggestions for how to track training hours for all employees. Each employee has a separate training sheet - it's broken out by training section with training items underneath. One of the columns on this sheet is Duration - this is used to track how many hours are needed for that training task. I need to create…
-
Formula does not appear to be working
Okay, first, here is my formula: =IF([Release Name]@row = "", "", IF(COUNT(ANCESTORS()) = 0, 1)) It is in the far right (second image) in the column named Is Parent, which is a checkbox. I only noticed this issue as a result of checking on these release numbers that are a variation of the same number with letters as a…
-
Duration and Predecessors: What to do when you have 1000s of rows?
Hi there, I have a sheet that contains original data as well as data imported from CSV files. We have a template that we use to copy the CSV data from different external sources. This template contains pre-built tasks and milestones, like this: The dates come in as TBD and the hierarchy is flat (no parent and child rows).…