-
sysadmin + groupadmin but cannot edit column properties???
For a sheet where I'm not the owner, but another licensed user in my team is, I cannot edit the column properties. Am I missing something? If not, then this really reduces the collaborative value of Smartsheet Thanks, Arnie
-
Forced dates when dependency is enabled
We are working to importa 1800 line project plan into smartsheet and have run into a dabilitating problem with the dates. What looks to be happening is that the “Duration” and “predecessors” fields are completely driving the dates for the tasks. Anything with a predecessor is automatically forcing the start date to be the…
-
Really LIKE the new sidebar
It seems that the new sidebar is being disliked a a lot. I'm wondering why so much. I've always found that there is so much in Smartsheet that is all over the place and have not used the features because of this. Knowing where to go and you know you've seen everything is good in my opinion. The summary section is fantastic…
-
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…
-
Vlookup from Excel to Smartsheet
My apologies if this has already been covered, but I didn't see anything specific to this subject when searching. I have a Excel sheet that has 45,000 + rows. The data in the rows are filled by 2 columns - United States Zip Code's and city's linked to those zip codes. This Excel sheet is used as a vlookup for multiple…
-
Form Submission Automation
Faculty can submit a request for a course copy via a Smartsheet form I created. In the form, they are required to enter the name of their Program Director/Chair. If the name of the person requesting the course copy is different than the Program Director/Chair, I'd like to send an automatic request for approval from the…
-
Column not auto-filling with formula
Hello, I am having a webform insert new rows at the top of my spreadsheet. As you can see in the picture, for some reason the formula in the third column automatically fills the new row, but the formula in the second row does not. Why might this be? Thanks!
-
Force Comment Entry
what code could I use, in a cell or range of cells, that would "force" a user to input a comment in a certain cell based on their selection in another cell? I have attached an example from my sheet - I would like, if a user chooses a "3" in column "sub rating", they are forced to enter a comment in the "comments" cell.…
-
Vlookup woes
I'm trying to do a VLOOKUP and am getting the result #NOMATCH for all entries. Essentially I want to look in the Instructor column in Sheet A, check Sheet B and find the Instructor name and return their ID number. The Instructor names are in the first column of Sheet B, like they're supposed to be, and the IDs are in the…
-
Additional workflow/automation actions
Scenario: In our project, we have a weekly reporting cycle. In some of our sheets, we have a field that is "previous status" or "previous actions" or other similar ones, you get the idea. Desired action: have an automated flow where, once the end of the cycle is reached (any configurable date, friday evening for example),…