-
Calendar Recurring Dates
Is there a way to have a specific day and month fill out on a yearly basis. Im saying about date of births and anniversaries. I have to manually enter the current year and it only appears once on the Calendar View. What I would like to happen is enter a date and it will appear on the calendar for the next X number of years.
-
Time Tracking - Hours and Minutes
I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it…
-
Adding months onto a date
Hi sorry I have seen this posted multiple times before but I can't get mine to work. I am trying to add the number of months in the "Monthly Review Frequency" to the "Previous Review Date" in the "Next Review Date" Column. I have tried this formula: =DATE(YEAR([Previous Review Date]@row), MONTH([Previous Review Date]@row)…
-
Calendar App multiple sheets
In the key features for Calendar App, it says "Create a Master Calendar - Combine multiple sheets into one master calendar." I can't figure out how to pull from multiple sheets. I currently have 1 sheet that has all our projects with a date range, and then I have a second sheet where holidays, vacation, etc. are entered. I…
-
How to add multiple IF statements to WORKDAY function?
Hello trying to add multiple cities to a workday function. This is to subtract our ship day from the expected arrive by date. Currently, this is what I have =WORKDAY(F3,IF(OR(K3="CITY1",K3="CITY2),"-2","-10"),Sheet1!B$2:B$49) I want to add 2 more cities. The function can either be from another column/sheet that has the…
-
Progress charts
Hi, Can some one help me how to build a progress chart using smart sheet? Similar to the one shown below Once level is fine instead of shown 3 levels, would like to show particular day GREEN/RED based on ‘pending requests’ shown in the attached table Any help will be much appreciated Thanks, Basha
-
Gannt View lets you select display label for subtask. I want to do that with calendar view
Is there a way in calendar view to change the label? I love how you can do this in Gannt view and would like to be able to do it in calendar view. I have attached as screenshot of the function I use in Gannt view that would be helpful in the Calendar view.
-
Calendar view using the REPORT feature.
I like using the calendar view when using the report feature. My issue is that when I click on the item in calendar view (from the report), it shows me ALL columns from the source sheet. I would like to see ONLY the columns that are selected from the report builder. I am using the report feature to pare down the amount of…
-
In office tracker w/ Calendar view
I'm challenged by trying to come up with a simple, efficient and creative method to create a sheet(s) that I can use to track approximately 20 or so colleagues on what days they'll physically be in the office. We're moving to a 3/2 flexible work schedule that allows you to be remote 2 days of the week. I'd like it to be…
-
Calendar App - usage?
My organization is looking to host an organization wide calendar, with sorting, filtering and color-coding features. Would the Calendar app serve that purpose? Can the calendar be linked over/viewable in outlook? Can 2 forms feed into one calendar? Can others view the calendar without logging into smartsheet? Would love…