-
Cross referencing two Sheets
Hi All I am currently using a web form to collect data for a staff onboard systems which is working great, however, I need a way to cross-reference the data coming in from the form to a list of people I am expecting. until the vlookup feature arrive later this year any ideas on how to do this would be greatly appreciated…
-
Organizational Hierarchy
Has anyone used SmartSheet to capture organizational hierarchy or some type of org chart?
-
Does Smartsheet keep previous versions of spreadsheets?
I am wondering if smartsheet keeps previous versions of spreadsheets on the off chance of the sheet being completely deleted?
-
Edit content in Sights.
I just started using sights. I see that it is not possible to edit individual cell directly from sights, or am I mistaken? Is there a way to do this? It would be very helpfull if I could. I would also love to be able to edit the comments field directly from sights as well. Is this possible?
-
Individual Days Off
Is there a way that I can schedule individual days off and have them reflected in my Gantt charts? I know the options are available for across the board, but what about individual vacation days. Thanks!
-
Notify an assignee that the predecessor required to start work has been completed.
I am looking for a solution that will allow an email to be sent to an assignee informing them that their part of a project can begin since a predecessor was completed. Any help would be greatly appreciated.
-
Formating in Smartsheet
Cell merge function I have seen that this function is still not in place. Can anyone tell me when this function will be implemented? Or is there a way, where I can use a text in one my Project templates with an instruction text to guide someone through within my template, for example my due diligence questionnaire (DDQ),…
-
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…