-
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),…
-
Export row data to Powerpoint or Google Slides
Hey Team, I'm hoping there's a way that I can export row data to a slide presentation (pptx or Slides) similar to the way I can export row data to Google Docs. Anyone have any suggestions? Ideally each row would export to a different slide, and each slide would be in one presentation, but I'd be happy if each slide was…
-
Best Formula
I have a construction schedule with start and finish dates. I want the check boxes for the at risk column to automatically check off if the project is late starting or late finishing. Can anyone help me craft the appropriate formula for this? Is there a good formula for this? I was thinking it would be an if then formula…