I am sure this has been said before but I would love the ability to expand the primary column choices from just text to also date columns. This would be really helpful for us folks in manufacturing when it comes to daily metrics.
Sign in to see the current vote count, add your own vote, or leave a comment.
I'm surprised that date would be useful in primary, but of course there's some use-case. My gripe is, even when the column is locked to text/number, why not allow us to enable a dropdown list of options? For example, I want free-text in my primary column, but there are also a few important and often-used values which are especially meaningful, and I want the users to have those options in a not-restricted dropdown list (not least of all to control nomenclature, and thus ensure conditional formatting works properly, etc.). Seems like there's no particularly good reason this isn't available.
For you, wanting dates, I wonder if you could use the number that Excel assigns to dates. Excel assigns 01JAN1900 to the number 1 and every date afterwards is just the next whole number. So your post updated 12/05/22 is either 44693 or 44900, whereas today (06DEC2024) is 45632. You could do this with a formula in the sheet, datediff between the date and 01JAN1900, expressed as a number of days. Of course, to your point still, you couldn't have this very simple formula in the primary column.
I have a workflow with nearly 40 automations, half of which are email-based requests for updates with various sets of triggers. While I know the automations work, due to months of testing, when our system went live to the institution, I became very worried that the automations wouldn't run and I'd have no idea whether or…
Description: When users upload multiple photos in one action via the Smartsheet iOS mobile app, all files are assigned the same generic name and timestamp. This makes it difficult to identify individual photos and creates confusion in workflows that rely on accurate, unique file naming. Why This Matters: Industry Standard:…
I am proposing bringing a bit of pizzazz to Smartsheet by having celebratory animations for certain criteria. Think Joyful Animations in Outlook! My team was hoping to have some sort of confetti pop/gif/image when we close out a project or hit a milestone. Bonus points if it is configurable like the automations are.
