-
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?
-
Reports / Master Calendar
Hi there, it's me again. So here's the thing... We are a small test facility. We are trying to track jobs that are nothing like eachother using the same equipment and people resources. Sometimes we have 2 people resources on the same job. I know there currently isn't anyway to put 2 people on the same job and that I would…
-
Calendar sync
Can I sync the calendar with my Google calendar so only tasks related to myself show up?
-
"Processing" Today date in date range.
Good day all, I am collecting information via a webform and need some assistance with the reporting side of things. On the webform i am asking among other things to provide me with a startdate and a finishdate. My aim is to have automated reporting in the backend that will check if date Today is in range of the user…
