-
Future Date Issues
I've noticed that some of the dates entered, if too far in the future will revert to last century. i.e. January 5th, 2050 will work correctly if entered as 01/05/2050 but will think it's January 5th, 1950 if you enter 01/05/50 Also, once you enter the date as 01/05/2050 and it is shortened to 01/05/50, if you edit the date…
-
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…
