-
Two different triggers for one check box
Hello, I find this community very helpful in the search function, but I haven't participated much with my own questions. I'm hoping you can help. I have one check box that I would like to be triggered in two different situations "this OR that" kind of question. I have it programmed for one parameter, but I don't know how…
-
OR function to check a box
I am trying to get one box to check under one or another conditions. 1. when a certain cell has any text 2. When another certain box is checked The function I came up with follows, but it doesn't seem to work. There might be one small tweak I need to make, but I am still new to making formulas. Thanks for your help!…
-
Data from one sheet form to populate another
I have created a smartsheet that contains a form for my team to fill out. Once this form is filled out I would like that data to go to the main sheet that is viewable by my team and then populate another sheet that is viewable to the managers only. Is there a way to have that data when added to sheet one (main sheet) via…
-
Adding carriage return/line feed to calculated text
I'm pretty sure I know the answer (no) but ... can I format text with a carriage return in a formula? For example ="Line1" + \n + "Line 2" where \n is whatever I need to add to get this result: Line 1 Line 2 This article did not help.…
-
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…