-
Separate numerical and text values of differing lengths from a single cell into separate columns
How do I separate numerical and text values of differing lengths from a single cell into separate columns? For example, I'm trying to total the "AREA" Column, but due to having "SF" in the cell, it will not return a numerical value. The numerical values to the left are of differing lengths, making this problematic. The…
-
Solving for data issue when exporting data from external source.
I am trying to create a helper column that will help a colleague manage data that he needs to export from our inventory management system to evaluate in a team meeting. The issue is that he has currently been manually fixing a common data error where, occasionally, the name of an item is exported incorrectly. It always…
-
Is there a formula to indicate the change in status direction if updated in a given time?
I want to indicate with up/down arrows in a separate column, if the RYG status for a line item has changed direction in the last X days. e.g. if status went from Red to Yellow, Red to Green, Yellow to Green in the last 30 days - show an upward arrow; if status went from Green to Yellow, Yellow to Red, or Green to Red in…
-
How to find the lowest value number in a gap from a sequence of numbers?
Hello! I am currently working on a sheet that will allow us to assign a numbered item to a teammate and keep track of who has what numbered item for traceability purposes. The audit process has been completed and fully automated but I wish to make this more automated during the assignment process. Currently, we manually…
-
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…
-
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…
-
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…
-
Formula Question - Pulling in Multiple Criteria
I currently have a couple COUNTIFS formulas where I'm capturing the type by person by month as my criteria. I need to keep this criteria but add the condition that if multiple workers is selected in the source sheet (in a drop down with 3 options), to count the number in the correlating # of multiples column. The problem…
-
Formula in metrics sheet to average numbers in column in source sheet
I have a source sheet containing two date columns and a helper column containing a formula to calculate the network days between the date columns. (Example of several rows of my 600+ row source sheet.) In my metrics sheet, I want to calculate the average of the Days to Complete Termination column in my source sheet and I…
-
Formula for difference in time
We run events and are putting together the tech runsheet which has a column for: Time Start Time Finish Timer The timer column is what a speaker sees on their foldback monitor for how long they have left to present. I need this column to show the "difference" between Time Start and Time finish. (ie in the first row it will…