-
I am trying to extract data in an email address.
All the email addresses are formatted as first.last@domain.com Can someone please help me with a function that will extract the "last" from the email? Note: the first and last names will always be different lengths of characters, so i think i need something that will say something like extract after the "." and before the…
-
Multiple IF AND ISBLANK Criteria in Formula
What I'm trying to accomplish: If [Approved] is checked, change [Status] to "Complete" If [Ad RSS Link], [Subject Line], and [Done] are not blank, change [Status] to "Proofing" If [Ads Entered] is checked, change [Status] to "Proofing" If none of the above are true, [Status] will be "Waiting for Information" Here is the…
-
Need a formula to retrieve value from Sources sheet to Target sheet
In Source sheet i have 4 columns: Test ID, Description, Product A, Product B. In Source sheet, If values in Product A and Product B columns are not equal to zero, then i need values of Test ID and Description columns to be retrieved in Target sheet. Source sheet: Target sheet:
-
Finding the average of multiple rows given 3 criteria (Two Sheets)
Context- I am attempting to track the average settlement percentage for a given attorney at an opposing firm with a given client of theirs. In the first screenshot, I've listed that given attorney and their client in columns 1 & 2 (Sheet 1). We are using data from one of our attorney's tracking sheet (Sheet 2). It lists…
-
Countdown to future date not updating when sheet isn't opened
Hi All, I'm using the following formula to add a date countdown metric to a portal. =DATE(2022, 12, 1) - TODAY() The issue I'm having is that it's not updating unless the metrics sheets that I have the formula in is opened. Does anyone have a work around for this? Many thanks, BW
-
Apostrophe being inserted before Formula when using Smartsheet Forms
Hello, we have a Sheet setup with a Column which has the Formula =[Project]@row + " " + [Note]@row taking the info from the Project and Note columns. We also have a form for this sheet where you pick the Project and add a Note, what happens when we complete the form is a Leading Apostrophe is inserted in front of the…
-
change cell value to include {{column}} does not work same way as email workflow
I am using a Change Cell workflow to use the same feature of the email workflow of embedding {{column}} into the text. The same text that works in email workflow does not work in the change cell. In this example, if the Speed Limit Column is 100 and the Infringe Speed column is 121, the test that is produced should be…
-
Formula to return text rather than a number
Hi there, I have the following columns in use: Plan Expiry date (Date column) Date of Event (Date Column) Status of Plan (Text Column with Formula) I have used the following formula in the 'Status of Plan' column to let me know if a plan had expired when an event occurred. =IF(ISDATE([Plan Expiry Date]@row), [Date of…
-
CONTRACT EXPIRATION DATE
1-I am trying to reference another to provide results of contract expiration date - 2- I would like to display in a dashboard the percent of total contracts that has expidered, will expire in 1year, 6month, 90 days 30 days, 14 days and 7 days 3- finally if there was an extension, to input that date in a new column that…
-
Help with IF/AND formula for symbols
Hello! I am working on a formula to display red/yellow/green circles for project health, but I want to filter out projects that are closed. I have the formula working but when I try to add the AND part to filter out closed projects, I keep getting errors. Here's what I have: =IF(TODAY() = [Estimated Finish]@row, "Yellow",…
