-
Gantt view by project days, not dates.
Question, I am trying to create a Gantt chart that tracks a project in terms of days, not dates. For example, Task 1 will run from Day 1 to Day 5, Task 2 from Day 3 to Day 9 (instead of August 3rd- August 8th). Is there a way to do this?
-
#INVALID DATA TYPE
Hi All! I have two cells next to each other, Date Assigned and Date Due. When I add the date assigned date, I want it to auto populate the Date Due as 3 business days in the future. My formula works =WORKDAY([Date Assigned]86, 3) but when I have no date in the Date Assigned cell, the Date Due says #INVALID DATA TYPE. Is…
-
Scheduled Backup
I am trying to set up a backup on our main sheet (This one has info from other sheets linking into it) I am able to select schedule recurring backup for my entire workspace, but we don't need all of that. All we need is one sheet to be backed up each week. When I right click on the sheet it will allow me to request a…
-
Using Smartsheet as the only tool vs SharePoint, shared drives and OneNote
Our department is looking at how we file electronically. We have used a combination of OneNote, SharePoint, Shared Drives and we just started using Smartsheet. Smartsheet seems to allow for all communications, files, etc to be stored there. Has anyone moved to using only Smartsheet for everything that has anything to do…
-
Smartsheets for medical practices
Does anyone know if smartsheets solutions can be used to manage medical projects? This would include documenting information that would flow via api into an existing enterprise system.
-
looking for a chain of custody or asset tracking template
We are looking at creating a chain of custody document to track assets that get transferrred to other people. Are there templates out there or does anyone use this?
-
Having dates change by being linked to previous dates
Hello all, Ive looked and cant find this one ( or i didnt type the right thing in search ). I have several deployemnet dates set. Im wondering if I can have all dates change if I change one above them, EXAMPLE: On 03/14/17 I have a deployment scheduled. On 03/21/17 I have a deployment scheduled. On 03/27/17 I have a…
-
Slow Reaction time
Hi. the reaction time is PAINFULLY SLOW. My sheet is only 120 rows by 35 colums. 21 of the columns have formulas in them. Other than that there is nothing. Not all colums are filled in. Is there a tweek or trick I can apply. If I move too fast it also freezes up. this is going to highly irritate co-workers. Help? LE
-
create a location updated index from 1-10
I need to create a count of 1-10 that always stays at the top of the column in the correct order even when the sheet is sorted and when web forms are used to input information to the top of the sheet. Sounds simple but I have no clue how to do this without drawing a circular reference and without the ability to reference a…
-
Auto-Number Fields on Form Creation
Hi Is there a way of Auto-numbering Fields during a Form creation? Put simply can you automatically number questions 1, 2, 3 etc? Or can this only really be done manually by changing the column titles? i.e. 1 - Where do you live? (for example) Many thanks Nick
