-
Create birthday calendar with reminders - no year entry
We would like to use SS to create an employee birthday calendar and set the due date as their birthday - without using the birth year (so we don't have to recreate the wheel in subsequent years). If I set the birthday (date) column, I have no option but to use the current year. OR, once the sheet is set up, is there a way…
-
Modify Calendar View?
I'm trying to take a list of dates and associated activities - potentially up to 15 per day -- and display them in a calendar format...either traditional or agenda layout. I have curriculum maps -- material we will cover each day for 6-8 weeks - listed out in spreadsheet format and then want to turn that into something…
-
Conditional Formatting in Calendar Not Working on Refresh
I use conditional formatting to change the background color of certain items in the Calendar view. Smartsheet seems to have a bug where the conditional formatting works perfectly when going from the List view or Gantt view to the Calendar view, but when I refresh the browser within the Calendar view, the conditional…
-
Copy/Paste rows changed "created date"
I had to copy and paste a few rows within one of my sheets. When I did, it changed the "Created" date and time to when I pasted the rows. How do you ensure that this column always reflects the proper date, if rows have to be copied and pasted? Thanks K
-
Using smartsheet for grant writing
I am a grant writer at a nonprofit and my development team uses smartsheet. I am at the beginning stages of using smartsheet and want to use it for EVERYTHING related to my grant writing (calendar, deadline tracker/notifier, links to emails, links to webpages, task list, grant applications, anything else you can think…
-
Why does moving a subtask or milestone in the Gantt view preserve durations...
but rekeying an end date alters the durations? I'm using predecessors and start-to-finish dependency to work backwards from a deadline for a task. The durations for subtasks must remain fixed. If I type in a new deadline for the task, the durations adjust—this is not what I want. If I slide the deadline in the Gantt view,…
-
Universal Date Setting for Date fields
Can a Universal Date Setting be added to Smartsheet settings please?
-
Format date in project schedule to include day of week
Hello, Is there a way to change the format of the date within a project schedule to include the day of the week? Right now the format is 5/13/15, where it'd be much easier to read & use if it was Wed 5/13/15. any help is appreciated.
-
Recurring Task Lists
Is it possible to set up a recurring task list so that when I check a task as "done" the due date automatically recalculates to the next due date? Ideally it would create a new task with the new due date that was not marked as done. Thx.
-
COUNTIF Formula for Week Of
I am trying to do a COUNTIF formula of a list of cells that contain dates to determine if any of those dates end up on a given week. I think I need to use COUNTIF and then have a > and < on the date but am not sure how to do this. I could also reference the Monday DATE() +4. Anyone have any ideas?