Trending in Formulas and Functions
-
Date and Time Separator Formula
Hi Community, I'm looking for assistance with creating formulas in Smartsheet to separate a combined DateTime value into two distinct columns: one for the date and one for the time. "Date" Column: Contains both date and time values "Date Only" Column: Should display only the date "Time Only" Column: Should display only theโฆ
-
Min Collect Help - date returning zero value
Hello, I am looking for formula help where I want to return the earliest date in a range for different workstreams groups on a project. The source sheet is formatted as a date field, and the formula used below is returning a 0 no matter what I do. Any suggestions? =MIN(COLLECT({Project Plan - start date}, {Project Planโฆ
-
Returning matches in Multi-Select column for exact match of value and excluding "Value" + "Text"
I am seeing if I find a match for a value in a multi select column and using the HAS formula. It is returning when the string is found, but also when a string plus additional words is found. For example I am looking for if the color "red" has been selected in the column, but it is also pulling in when "Red Rose" has beenโฆ