-
How to convert dates to Long Form Date format?
I understand that date formatting is normally set in "Personal Settings" but in order for the SmartSheet Merge to work for a problem I'm trying to solve, I need to convert the date to the long form (February 11th, 2016 instead of 11/02/16. Is there a script or IF statement that I could use to make the change? Thanks, SRC
-
Summary Tasks Show in Google Calendar
Even if I uncheck "Display Summary Tasks" on the Calendar settings, Google Calendar shows the summary tasks from my smartsheet. Is there a way to prevent these summary tasks from syncing to Google? Thanks for any help! Best, Max
-
Removing Projects on an ongoing spreadsheet
Is there a way to have the projects on an ongoing spreadsheet be removed or moved to another location so the spreadsheet doesn't become cluttered?
-
Show changes made in the last 24 hours (only)?
Is there a way to have a smartsheet highlight only those changes that have been made in the last n hours? I look for changes to one of our smartsheets every morning and copy them to another file. We have yellow change highlights turned on but I'm finding that they can remain there for days, making it hard to see only…
-
Approving Changes Made to A Shared Sheet
Hi all, long-time listener, first-time caller. I have been tasked with discovering a way that a sheet owner can control updates being made to a shared sheet through some form of 'approval' feature or process. My scenario is this: there is a master sheet displaying all approved, company-wide projects, complete with columns…
-
Non People resource assignment
Hi Hoe do I assign non people resources to a task. e.g. a piece special equipment to do a job so that I can see the utilisation of the equipment.
-
Feature request: Weighted options in dropdown list
Hi, When sending out web forms with dropdown lists it would be great to be able to connect each option to a number. That way we can run avarages and calculations on the results. Fully agree (=5), Somewhat agree (=3), Do not agree (=1).
-
Multiple colors applied to one cell
I am pulling data from an Excel sheet listing resources. These resources (cells) are color-coded based on availability, training, etc. In a couple of instances, some resources might be available AND billable and, consequently, require 2 different colors in the cell (from the legend). In Excel, there is the ability to…
-
NaN in date field
Hi all. Last week I added row and entered a date in one cell, using the smartsheet app on my android tablet. I got the usual "Changes to XXX" email and it shows the correct date on the new row, 11/02/16. However, when I looked at the sheet today it shows 09/02/NaN. I was relying on this date to send me an automated email…
-
Create a new report/ count toward sheet limit?
Whenever I create a new report, does the report count against my sheet limit?