-
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…
-
Calendar View - can't drag tasks when Due Date uses WorkDay function?
My SmartSheet has Task Due Dates that are calculated using the WorkDay function. For example, if a recurring monthly task is due on WorkDay 1, that calculated Task Due Date would become Monday, January 3rd, rather than Saturday, January 1st. Approaching the dates in this way makes it easy for us to rollover the Task List…
-
Automation
Could you help me ? do you think i did it right? I want to automatically send a reminder mail to the responsible persons on the 60th and 15th days. the trigger should work every day and; it only needs to work on the 60th and 15th days of the contract date. example1: 60 days left until the end of the contract. example2: 15…
