-
Automate Values using keyword only
Hello, Is it possible to automate values in Dropdown list selection column once I enter a value in keyword column? Also if I change the value in keyword the Dropdown list selections will change also. Please see image below for reference. Thank you.🙂
-
Text to columns in Smartsheet
Hello, I am trying to separate text to columns (separate email address and add two separate columns with First Name and Last Name information. I want to add an additional column to display First and Last Name in addition to the email column. As an example, see below: FirstName.LastName@gmail.com Additional Column 1: First…
-
Column formula - for increasing same value in array
Hi, I would like to see if it is possible to change the below FirstInstance formula into a column formula as I am using Data Shuttle to import new/revised data into the grid. FirstInstance Formula: =COUNTIF([Request Id]$1:[Request Id]1, [Request Id]1 = [Request Id]@row) + 0 DaystoClose2 col Formula: =IF(FirstInstance@row =…
-
Help with Nested If Function
Hi, I want to change the Health column based on several conditions; If the due date is past due, red; if the due date is less than 5 days away and % complete is 0, if the due date is less than 5 days away and % complete is 50% or less then yellow, otherwise green. I cannot get the function to change health to green when…
-
How to split text to support reporting?
Hi, I am bumping into a design / Smartsheet limitation issue. I use an request inventory sheet to track client change requests. CR are submitted via a form. One of the field helps tracking the category of the CR (business feature grouper). I had to concatenate 2 types of data to workaround the form and the fact that I…
-
Formula to identify current approver
Good morning, I have a worksheet with a multi-approver workflow on it. Upper Management wants a report that shows who is the current approver without having to see all of the previous approvers. Does anyone know, is there a way to construct a formula that would identify which approver the request currently resides with?…
-
Combinging two IF statements
Hi, I need help combining two IF statements. They are constructed the same, but I want them to be one entire formula for a specific cell rather than two seperate formulas. They both work serpartley, but I keep getting errors when trying to combine them. Essentialy, it is when the Department column is blank it will…
-
Using COUNTIFS and NOT together
I am using the following formula and getting an error: =COUNTIFS({Master Discrepancy Log 2021 Owner}, $[Primary Column]@row, {Master Discrepancy Log 2021 Product Type}, "Prime Share", {Master Discrepancy Log 2021 Month Opened}, 2, {Master Discrepancy Log 2021 Year Opened}, 2021, {Master Discrepancy Log 2021 Discrepancy…
-
Parent Status Updated based on Child Status
Hello! I'm sure this is a super simple formula but I can't figure it out. I would like to update the parent row status to say "FILLED" if a child row has a status of "HIRED", otherwise the parent row is "OPEN". I also need to overwrite the status of the parent row if there is any case where the status needs to be "ON HOLD"…
-
How to return specific Column from a Multi Column Cross Sheet Range
Hi Folks, I have the following formula used to track specific assets: =SUMIF({EventDate_req}, $DateNeeded$1, {Asset2_Range}) This adds up the count in each row in the Asset2_Range that matches the date needed. We created individual one column ranges for each asset (Asset1, Asset2, Asset3) etc. Problem is we are using too…
