-
CALENDAR VIEW Date is not showing accurately
Some of our shared users are having trouble with the date showing up accurately in the Calendar view. I cannot seem to find a setting that would allow this to be changed. I have tried refreshing the screen, closing the browser and restarting it. but still they see the dates with Month 7778 example shown in screen shot…
-
formulas
When I am trying to add several variables using =sum( formula and scroll to locate other variables, my formula is cancelled and I receive an error code. As if I can only use variables/amounts on desktop screen and not above or below.
-
Activity status column based on due date and % completion
Team, It will be great if someone can help me to Color Code/Highlight the activities in my smartsheet based on target completion date & % Completion column that is manually updated. What I would like to do is: IF target completion date is in the past & % Completion is less than 100% mark it as “PAST DUE” IF target…
-
Reporting on Tasks Past Due by Person
I'm looking to collect ongoing data/statistics on how many tasks reach past due. I would like to collect this by person assigned and across all projects and then by month. Any suggestions on how to tackle this using smartsheet?
-
Sending a Web form weekly basis
Hello, Does anyone know if there is a way to send a web form on a weekly basis? I have attempted to create an auto workflow but am only able to create an update request. The issue with this is it overwrites the content that was in the row as opposed to adding it to a separate line. If anyone has insight into this, please…
-
Pie chart arms?
Is there a way to add arms to the data labels for pie charts? Some of the labels are on top of each other and impossible to read.
-
Is there a way to merge two Enterprise Account Users?
Currently there are two Enterprise Accounts created for some reason. So I am unable to add an Enterprise User from 'Enterprise Account A' through our User Management in 'Enterprise Account B'. As per instructions, if we delete these users from 'Enterprise Account A': 1. Will their Licensed User license be removed from…
-
Some Vlookups returning #NoMatch, others are fine
I have a training tracker with all the staff, their managers, locations and whether or not they have completed training. I have multiple vlookups in columns manager, location, role, status and classification. The vlookups are referencing an HR file that we have that has all the raw information. As you can see below, many…
-
auto completion date
Hello, fairly new to Smartsheet and I have a question. We have a sheet for PO requests and one of the columns is for "Status" , it has several options from a drop down menu. What I would like is for our "Completion Date" column to automatically show the date when a status is changed to "Complete". I don't care about any…
-
Interaction with Microsoft Sharepoint
Long story, short as I can make it. I started to create a list of links in Microsoft Sharepoint until I discovered that it seems to be woefully short with sorting, making child entries, etc. In Smartsheet, I am able to accomplish what I am trying to do with ease. Here's my question. Can Smartsheet and Sharepoint interact…