I have created a form that populates a sheet and the form asks multiple questions and then the sheet uses the answers to create 3 costs, so far very simple. However I want another cell to automatically display a result based on the 3 costs provided. I'm a contract manager and I will have 3 options I wish to display they…
I have set up my own annual leave system using Smartsheet and the approval workflow. The employee has to complete a form which then inputs the data for their line manager to approve or decline. However all entry's are added at the bottom of the sheet and then above them are master(parent) rows with children under them with…
I have a sheet with a single row of data: Primary / Date / Count of <type1> Projects / Sum of <type 1> Project Days / Count of <type2> Projects / Sum of <type 2> Project Days / Total Projects / Average days Primary column has a 1 in the cell. The rest of the row cells are formulas. Date is =today(). I want to copy that row…
I have successfully enabled a webhook to communicate with an Azure HTTP Trigger function which will run a Python script and perform other actions. This webhook only looks for row adds. I need a webhook for looking for an update to one column but don't understand the API documentation for scope and subscope. Does anyone…
Howdy - I feel like I've tested this every which way but didn't want to throw in the towel until I asked the community. Is there any way to run an automation (specifically "Copy rows to another sheet") based off a changed value via column formula INDEX / MATCH? My goal here is two fold: limit the number of columns added…
I have a Smartsheet form that when submitted triggers and automated email. However, if two forms are filled out within a minute or two of each other it combines both entries into one automated/combined email that is sent out. I want each form submitted to have its own automated email, how do i turn off the "combined"…
I'm looking for way to allow a restricted view (sub set of columns) to and an external organization (I've set up a View Only user group). 1st try: Create a report with just the columns - FAIL. I still need to grant the view only permission to the source sheet 2nd: Create a 'query sheet' that 'VLOOKUPS' just the columns -…
I am trying to run an automation workflow "ASSIGN PEOPLE": Trigger = when rows are changed/TASKS(column)/Changes to/any value/when triggered Condition=TASKS(column)/is not blank Action-Assign people=EXPEDITOR(column)/a contact The expeditor column is set up for contacts. When I run the automation it pulls up their email…
I have set up an alert to notify me when a row changes, but instead of it just sending me the rows that were changed, it's also including the parent row (ROW 113 in example), where no changes were made. The 'Objective' column that I'm bringing in uses the =PARENT(OKR@row) formula so that I know which objective the…
Question- I have 3 check marks within a row. My goal is to figure out a way to have only one of those check marks "checked" at any given time, not multiple. So if one is checked in one column and i check another box in another column then it will remove the existing check mark in the other column. Anyone?
