Record an Approver Name once Approved using Automation
Hi, I am looking for a solution to record the name of the approver when using Approval Request automation. I can see there have been few questions/discussions on this, but can someone point me to the solutions - without using Zapier :) For example, a request to approve a report is being sent to John, Jack and Jerry. Jerry…
Can someone help me put together a complex logic formula?
I'm looking to put together a formula that outputs a status based on a few criteria. This formula should output "Denied" by default. If the [Price] is $500 or less and [ManagerApproval] = "Approved", output "Confirmed". If the [Price] is more than $500 but less than $1000 and [ManagerApproval] = "Approved and…
Populate Column With Unique Values From Another Sheet
Hi all! I have a sheet, where tasks are entered and assigned to employees. Every task belongs to a certain company, which is specified row by row (every row is another task), this describes the first sheet we'll call "Requests". I want to create another sheet to summarize the data of every task for every company, this…
Help with multi-conditional contains formula
Hi there! I am struggling with finding a formula to assist with the following two scenarios. Please see screenshot for layout of columns for reference Scenario 1: If the Child Account column contains TN Oncology and the Task Name column contains CDA Signed I want the value that is populated in the Status column to pull…
Pulling Data from Smartsheet with a form to another Smartsheets
Hi, Hope someone can help! I have a form set up on one smartsheet (1) which is to be sent to new onboarding colleagues to get some information. When the fill this out this auto-populates the rows in that smartsheet (1) which is fine. But I have their names listed on another smartsheet (2). Once they have filled in the info…
Allow Forms to be Saved to a Workspace
Hello, I am submitting this idea/enhancement to allow forms created from sheets to be saved on their own (as forms) in a Smartsheet folder or Workspace. Right now, it can be cumbersome to get to the form.
Nested IF(OR statements column formula
Hello smartsheet Community! I'm trying to have a status column update based on three approval columns. There's several reasons why a row would be green ("Yes"), yellow ("Hold"), or red ("No"), so I'm trying to use nested IF(OR statements. It's possible I'm overcomplicating this and there's an easier way, any help is…
I need to indicate when a task is complete, in progress, and overdue based on two criteria
This is the formula that I have currently but it is returning the error "#UNPARSEABLE"; Basically I need to indicate when a task is complete (Green), in progress (Yellow), and overdue (Red) based on two criteria, if a date is reached and the box is checked (Green), if a date is reached and box is unchecked (Yellow), If a…
URL Query String for a Multi Select Drop Down Field
Hi, I've read posts with similar questions. What I can gather is I have to parse out each of the drop down options into my query string but the posts I've read all have the solution incorporated after the URL? the adding & and list the field again with the second value and so on. My formula is all split up into individual…
Font and Image Options
PLEASE PLEASE provide additional font choices and smart art, clip art libraries, especially when designing dashboards.