-
Recurring Weekly Tasks
Hello, I've seen a couple of entries related to this, yet I think my question is simpler. Is there a click somewhere that would automatically populate a weekly task? For example: "Review Meeting", from 3/31/18 to 7/31/18, must occur weekly. Is there an option for this, similar to my Google Calendar? Or do I need to copy…
-
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?
