-
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…
-
Drawing row linked data into another sheet together?
Hi All! So I have a sheet with a list of tasks, a checkbox for completion and a due date. In one of my other metrics sheet, I am trying to generate a list of my top 5 overdue tasks. I have managed to get a list of the most overdue dates with a SMALL(COLLECT...) function which will only count dates that are not listed…
-
File attachment counted as a change to a row
I currently have two workflows set up: (1) Payment approval request after an event: employees submit request with invoices attached as a file for approval (2) Payment approval request before an event: employees submit a request for an approval, the request gets sent to a supervisor, and once the supervisor approves, an…
-
Child Text Indented formatting
When you have a Heading Row and Rows below that are Children of the Heading Row, is it possible to have the text Left Align and not be indented? Thanks, Tm