Formulas
Discussion List
- 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.
- 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…
- 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 e…
- 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 funda…
- 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 actua…
- 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
- 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 ("atte…
- 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 for…
- I have a column of ID's extracted from a larger string. I need to extract the numbers ONLY. The column looks like this: The numbers will not always be exactly in the same starting position, nor will t…
- Hello, After much research and experimenting, I am still stuck on a formula for my status log. I am trying to create a formula that counts how many business days a task is past due. Therefore, the for…
