Trending in Formulas and Functions
-
Formula for return value from a seperate sheet column if another column is one of 3 values
Hello, I am trying to create a formula that returns the value of a lets call it Column A in a seperate sheet if Column B in that same seperate sheet is any of 3 different words. Here is the formula as I currently have it. =JOIN(COLLECT({Scopes Range 3}, {Scopes Range 2}, OR(@cell = "In Progress - On Time", @cell = "In…
-
If Formula help
Hello, I am trying to write an IF formula for my smartsheet that adds the letter A, B, C or D or E to a column pending on a dollar amount listed in another column, but I cannot seem to get the ranges to work right and everything is listed as either A or B. Current base formula: =IF([Total Assets]@row >= 1000000, "A",…
-
Automate formula based on dropdown
So I have a sheet with multiple columns. Rows automatically appear based upon a Power Automate flow from other sources and rules. It works great, but now I need to auto populate a calculated formula in one column based on a drop down selection in another. The two things I thought of don’t seem to be working. Example: I…