-
Copy Rows Between Sheets Based on Checkbox
I am trying to create a calendar or events based off a master list of events on another sheet. The source sheet is a master list of all possible events. That sheet contains a column of check boxes. When a checkbox is checked I would like it to automatically copy that row from the source sheet to the destination sheet. The…
-
Recurring / repeating tasks & time
I know this has been requested before, so I'm recurring / repeating this request lol. I know you can use formulas but it's a workaround with limitations. Right now I have to use my Outlook calendar for recurring tasks which prevents me from using the Smartsheet calendar which leaves me managing tasks using both Smartsheet…
-
Dateformat changes in external linked sheets
I've created a table to manage our school-year. Out of this table several calendars should be created. As there is no possibility to create more than one calendar out of one tablesheet I worked with markups and created external links to some other tablesheets so that there is one sheet for every group I have to manage.…
-
Dashboard vs Master Calendar vs Sights ?
Hi Trying to step away from excel, I am fairly new at using smartsheet and am looking for the best way to view simultaneously multiple sheet to better manage the deadlines of our projects. Being an expeditor, dates are the driving factor to help me guide the multi-disciplinary teams. Since we have multiple deadlines…
-
Pushing dates to calendar
Hi Can anyone help with a formula that only pushes a certain dates to the calendar? I want to publish only certain dates. I tried the filter but you can only set the default view on filter when sharing not publishing. Thanks Emma
-
Date validation
Hi... I tried search on validation of Dates, especially while selecting while selecting dates from form. I need to restrict use of past dates and user should be able to select dates which is today or ahead of today. Please suggest.
-
IF () formula, Change Status Dependate on Date
I would like to build a formula so that status will change to "Red" and type will change to "Renew" when date is past "Expire Date". I've applied the two formulas separately at the top of each corresponding column. But so far it just changes it to Red or Renewed automatically, without the date dependency. Can I make this…
-
Overriding Non-Working Days
Most of our projects include M-F working dates, however at the end of each project there is often a conference or event which may take place over a weekend or other non-working day. I'd love to be able to override and enter tasks on weekends for these instances without turning the entire project into a 7-day work week…
-
Set Return Date as today +5
hi there, i have a form to manage my graphic designer's projects. It includes a To Graphics date and Return to You date. How do I set the Return to You date to be today +5 or greater?
-
Calendar View - Click into Inforamtion
Hi I've built a number of calendars of a report but when i click on an event in the calendar to get the rest of the information its bring back all of the information from the original source. I only want the information which is in the report. How can i get the calendar just to show the detail on the report that the…