-
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…
-
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!
