-
Macro or VBA funtions
I'd like to be able to create a macro or VBA code that would allow me to create a job folder on our local server using data from my smartsheet. The VBA code in Access looks like this: Private Sub cmdCreateCaseFolder_Click() If Dir("\\MA021SFS01\NorthEast_EWP\2018CaseFolders\" & Me.Project# & "-" & Me.Project Name & "-" &…
-
Multiple Selections from a Drop Down
Hi, am creating a smartsheet to collect certain client information & documents to provide a certain service. While creating a form which could be sent to my clients, I've realised that it only allows for a single selection of a document off all the documents that I've listed in the drop down. However I need multiple…
-
Adding Outlook calendar entries into a Smartsheet
Is it possible when creating a calendar entry within Outlook, to have that entry automatically populate a new row in a Smartsheet sheet?
-
Highlight If Older Than 'X' Days
I'd like to use conditional formatting to highlight a row or cell if it's older than 30 days. It's helpful for us to see which tasks are stale. However, there's only an option for "In the last 'x' days" or "older than (a date)". Has anyone found a good workaround or submitted this as a feature request?
-
PLEASE tell me what is wrong with this formula
=IF(Status8 = "Complete", "Blue", IF([Due Date]8 < Today8, "Red", IF([Due Date]8 = Today8, "Yellow", IF([Due Date]8 > Today8, "Green")))) Very new at this, but I can't see the problem...
-
Dynamic Sum from Multiple Sheets in a Workspace
Hello, I have a workspace full of our active projects. Each tasks has a status (not started, in progress, complete) and I would like be able to see the total numbers of these tasks statuses across all the projects. I already have columns that count the number of each task status in the individual projects, but I would like…
-
REALLY don't like the new layout!
The new look/functionality of the sheet is much less friendly. Takes a lot more clicks to get through and I now always have to close the left pane to see my sheet properly. Also, the left pane list keeps changing so I have to hunt for my sheet each time. When you had the tabs at the top I knew where to find my sheets…
-
Resource Allocation and Manipulation
Hi, I am new to Smartsheet and I am trying to create a view for my team where I can see all of the tasks, across multiple sheets (projects), that individual team members are assigned. In other words I want a view where I can see all assigned tasks, with task names, who the tasks are assigned to, dates, and a Gnatt chart if…
-
Card View / Contact List
Hi there:) I have a sheet used as a "Maintenance Request" sheet. It is populated by a form. Each person submitting a request provides their name/email into the "Submitted By" column. This allows them to receive an alert once the job is complete. I have frustration coming from the maint dept. when assigning a job/task…
-
Sheet rules missing
I am an admin user. I updated a sheet with multiple rules. The rules show up the sheet when I open it. But, when one of the other users on our account open the sheet, it is missing 4 rules.