-
Return Different Amounts of Characters from a cell
Hello Smartsheet Community, I am trying to come up with a formula to pull the 3 or 4 characters from the beginning of a cell. The Foundry ID is what I am looking for (pictured below), but the lengths varies between 3 and 4 characters. Does anyone have any ideas on how to accomplish this? Thanks!
-
running sum without explicit cell reference
Hi i have a formula that sums values in a column from row 1 to current row =IF(CurrentRecordHelper@row = 0, "", SUM(CurrentRecordHelper$1:CurrentRecordHelper@row)) is there any way to replicate this without the explicit row reference ($1), so it can be converted to a column formula many thanks in advance Andy
-
Convert formula to column formula without losing existing cell data
Hello, I have a sheet where I'm trying to add a formula as a column formula so that it applies to new rows, the issue is many cells in the column already have data (Date column) that I don't want to lose. The formula is an INDEX/MATCH that is referencing another sheet to obtain a modified Date. I have a trigger to copy a…
-
Formula to Trigger Checkbox if Date Meets Criteria
Hi everyone, I have set up a formula column for a checkbox that I would like to use to compare against a date field and decide whether check box should be "checked" or left blank. Essentially I'm going for: IF the Date on the row is greater than X amount of days old (for example lets say 90), then true (box is checked),…
-
if formulas, and adding status symbol (Empty, Quarter, Half, Three Quarter, Full )
Good morning! I need some help with these Smartsheet Formulas. I don't even know if it is possible, but I am trying to get a formula written that captures the status of column "Complete Date". As people fill in the date they completed their task, it will translate the status symbol to the appropriate amount. I am just…
-
Formula in Date Column
Hello, I am trying to get a date value from another sheet in a date column using Index(Collect(.......),1) function. However, every time I add a formula in date column it converts to text by adding a ' sign. For Example: Sheet1 has following columns: Location Project Start Date End Date ... .. .. .. I want to move Start…
-
checked box formula to use for dashboard?
I'm trying to create chart that will show cleared vs uncleared roles. I am trying to apply a countif formula for my sheet but it's not showing the counts. I am using the formula below. Am I doing something wrong Please help! Thanks, Nyasha
-
Pull the first non-blank value from a range of cells in a row
Hello, I have a series of columns that will be filled with a project name (from a dropdown) depending on which column is filled out from my form. I want to have a sort of master list column, that will display the project name for any given row (since otherwise, the project name will be in different columns depending on…
-
How to sort values using formulas? INDEX(COLLECT, COLLECT, VLOOKUP?
Hi, I am trying to sort the values (Machines) based on the "OEE Current Month Column" and referred it to the "OEE_C" (used Large formula). I have used 3 formulas to get the CM Machines sorted based on the OEE_C, first I have used VLOOKUP but when it reached the same values it stop showing data or leave it blank. 2nd, I…
-
# No Match errors with INDEX/MATCH formula
Dear Community I am having the hardest time debugging some #NO MATCH errors with my INDEX/MATCH formula. I have triple checked and can’t find any reason for things not to match. The rows right above and below work fine. I am pulling in the percent complete into a summary view sheet. I am matching on the site name,…