-
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
-
How do I find a smartsheet expert for hire to help build out our workspace?
I am building out a new workspace for some large marketing intergration projects. I am way over my head with smartsheets, but I have used it to complete amazing M&A sheets. I want to start intetegrating smartsheets into the operating side instead of just the due diligience side of the business.
-
Can't change task bar colors
My AA left unexpectedly and I took over her role as administrator and owner or the sheets/reports she created. Problem is I can't get the color palette to come up to change the task bar colors no matter what I try. What am I missing?
-
Task bar conditional formatting for calendar view (non defined task lengths)?
Hi guys I'm trialling out smartsheet as a content calendar, and as such I'm only including one date (publish dates) - so the sheet won't work as a gantt (which is fine) HOWEVER, I would need to apply conditional formatting to calendar view (to create an automated colour-coordinated content calendar) but it seems I can't do…
-
Task bar colors in report calendar view
The taskbars in my report calendar view aren't reflecting the taskbar colors in the underlying sheets, making it hard to tell which sheet the task is from. Anyone got any insight? Thx.
-
Calendar view in Sights?
I have a report that I use as a "Master Calendar" for vacations, major milestones, etc. How can I put this into my Sight dashboard in "Calendar" view? When I insert the report as a widget it only allows it to come in as "Grid" view. Thanks, Armen
-
Displaying multiple column values in Calendar view
I am storing data related to issues in the smartsheets. How can I show the issue number and priority in the calendar view?
-
Enhancement Request: Calendar View things
1. In the Gantt view, user can select starting day of the week. The ISO standard is Monday, so it would be nice if I could show that in the Calendar View too. 2. I would like to set up a Report that shows the Calendar Two Week view and then publish it. However, it defaults to month view and can be changed by the end user.…
-
Auto Linking Data between sheets
I'm new to smartsheet so sorry for the newbie question. I have a change request log sheet that captures our change request approval process and I would like to "publish" and approved change to a smartsheet calendar. Is there a way to do this? The data I'd like to publish would be a subset of the data in the change request…
-
Need a Column Property type that is "clock" or "time of day"
As an event management company, we have on-site event schedules that require a "start" and "end" time column. Those columns need to reflect the time of day and currently we have to create a whole drop down list of 24 hours to choose from for those columns. Am I missing it if it already exists? Or, if not, it would be great…