-
How to count umbers in row without letters
Hello, I need to count numbers in rows but there is added letters, is it possible to count all numbers without letters? I need information as displayed in image.
-
Conditional formatting for dates that are X amount of time in the past
I have a sheet where I would like one column of dates to be conditionally formatted to show if the date is greater than 5 years in the past. For example, once a record is greater than 5 years old then it must be archived. We would like to easily see when this occurs or be able to create a workflow to move them to another…
-
Find Matching cells between 2 sheets
Sheet 1 – thousands of registrations over many years and is considered a big archive and cannot be edited. Sheet 2 – a live sheet with registrations that is changing often, few entries and cannot be edited. Sheet 3 – my sheet that I want the following data to feed to. Sheet 1 has loads of archived entries. I would like to…
-
UTC Date Fix - Response Required
I've not been active on this site over the past 2 weeks or more, simply because I'm becoming increasingly frustrated with the limitations I'm faced with because of bugs, oversights and a lack of fundamental features. Primary for me is a fix to the UTC Server vs Local date issue. I've spent time trying to get around it with…
-
Split Multiple Selections In Single Form Into Individual Rows (Core Product)
There have been a number of people asking how to make multiple selections in a single form and then have those selections broken down into individual rows, and the previous answer was always to use a 3rd party app, a premium add-on, or the API. Below is a set of detailed instructions on how to accomplish this within the…
-
How do you standardize addresses in Smartsheet?
Has anyone found a way to validate their address fields in Smartsheet? We are currently using a Smartsheet form to collect business license data and would like to integrate our data to ArcGIS to map the business locations. Currently, we are manually updating all of the citizen-submitted addresses which is a huge time suck.…
-
How to show/convert days to weeks on project plan
Hello All, duration column circled in blue is automated as per the project setting circled in red is all manual I know weeks cant be determined from entering dates so i entered weeks manually in actual duration column and it has set the dates, but the roll up is in days is there a formula I can use on another column to…
-
I want to add a formula to my sheet where i can calculate the current month last working date
I want to add a formula to my sheet where i can calculate the current month last working date from the date entered as the last working date
-
Return the max date looking at multiple criteria
Trying to add the most recent training completion date (column is date/non-restricted) using mulitple criteria, to include: email address, training type ("refresher", or "intensive") and status ("attended") to a designated column (date/non-restricted) on another sheet. The formulas below are pulling the same date into each…
-
Help Extracting data sets that meet criteria to new sheet.
Hello, I am new to smart sheets. I have spent the last week trying to find a solution with no luck. I am sorry if I am asking a question that has been, probably, answered a slew of times. I have a form built that collects data on visits to one of four locations. "Activity Tracker" is the name of the sheet where the…