-
New Line (Alt + Enter) in Formulas
Hi I have Formula for text rows: =Coulmn1 + " " + Column2 + " " + Column3 + ... Can I set up a space char as a new line (Alt + Enter)? So every cell will appear in a new line. I need this for Google Docs. Thanks!
-
Joining two formulas, IF and NETWORKDAYS
Hi I have the following formula but only want it to be run where my task is in a 'Not Started' status. =NETWORKDAYS(Start1, Finish9) Is there a way to run an IF statement first as part of the above formula? I have tried running an IF statment in a hidden column but can't seem to link two together. Thanks Phil
-
IF COLLECT / MATCH COLLECT / INDEX COLLECT / VLOOKUP ?
Dear Community, I am trying to have an automatic filling of the column [Budget Max] while changing the column [Level] based on 2 other columns references: [Level attribution] and [Max Budget Range] with matching ROWS. If [Level]value = [Level attribution]value return [Max Budget Range]value of the same ROW of [Level…
-
Using SUMIFS, on a column that displays a $, based of a formula
I am looking at tieing 2 sheets together. My data sheet has a Column A, that is a check mark or not. Column B has a formula of "=IF([Column A]1 = 1, "$2"); therefore, it displays "$2" Column C has a month number, "01" I want a sumifs to sum all column B. But it display $0, and am assuming its because the formula in column…
-
IF/AND Statement with CountIf
I'm trying to create a formula that will look at my "Measurement" column for the text "PBI" at the beginning of this formula: =IF([Rank/Actual PTR]434 > [Score/Goal PTR]434, "PTR Exceeded", IF([Rank/Actual PTR]434 = [Score/Goal PTR]434, "PTR Met", IF([Rank/Actual PTR]434 < [Score/Goal PTR]434, "PTR Not Met", ""))). So, I…
-
Formlua Help
I need some help with creating a formula in smartsheet that works in excel. I'm created a formula in excel that split apart the employees year and month of employment. When I import it into smartsheet I get an error and not sure how to fix it. I also would like to create a formula that pulls over the correct accrual based…
-
If Checkbox is not needed, show blank
Hello Smartsheet Gurus, I have a spreadsheet that has a few columns as checkboxes, but when the checkbox is not needed, I want the cell to show nothing. Is there a way to do that? Thanks, Arryn
-
Create a Formula that compares Dates in 2 Columns and Counts a Total
Hi all, I am trying to write a COUNTIFS formula that compares multiple criteria. I need to Count all items in a column that have a status of "Completed" (column A), IF the items also have an Actual End Date within 2019 (column B) , and the Actual End Date is less than or equal to the Scheduled End Date (column C). I cannot…
-
IF / THEN Formula help
Hello, Im quite new to Smartsheets and was hoping for some code assistance. What i am trying to do is as follows: 1) Search a column (column1) in another sheet for a value, say 5. 2) When it finds that value, count how many checkbox's in column2 has been ticked Im trying to use an IF([column1]=5, COUNTIF(column2),1),0)…
-
IF/AND Formula
I am trying to create a formula to track invoices that are completed under 30 days. If the number in the "Invoice Duration" is less than 30 I'd like the next column "<30 Days" to populate with "Yes" If the number in "Invoice Duration" is more than 30 I'd like it to populate "No" Thank you for all the help!